Change text to either UPPER, lower, or Proper case.
Enter the below formula to column B
=LOWER(A1)
=UPPER(A2)
=PROPER(A3)
****************************************************************
=LOWER(A1) will change text case in CellA1 to lowercase
=UPPER(A2) will change text case in CellA2 to UPPERCASE
=PROPER(A3) will capitalizes only the first letter in each name in CellA3
No comments:
Post a Comment