Lyndsey has attended:
Excel Advanced course
Capital letter conversion
Is there a way in excel to convert words written in capital letters to lower case????
thanks
RE: capital letter conversion
Dear Lyndsey
Thank you for attending Excel Advanced Course.
Yes it is very simple to convert the UPPER CASE to lower case.
Please refer to the excel file that I have uploaded with this post.
A3:A12 is the original text typed in capital letters
Step 1: Enter the Function in B3 =LOWER(A3)
Step 2: Use the fill handle (the black small square at the bottom right corner of cell B3) and dragged it down until B12.
It should do the trick but what you