heatherm6
asked on
Capitalize first letter of text in MS Excel
I have a column of text in MS Excel that is in all caps. Is there an easy way to change it, so that only the first letter of each cell is capitalized.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can use this formula to convert ONLY first letter of the cell to Upper case and ALL others to lower
=CONCATENATE(UPPER(LEFT(A1 ,1)),LOWER (RIGHT(A1, LEN(A1)-1) ))
=CONCATENATE(UPPER(LEFT(A1
can use =PROPER(A1), which will produce "This Is A Test";
or you can use =LOWER(A1), which will produce "this is a test"