MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Converting UPPER to LOWER case


Posted by Ron on February 07, 2002 4:46 PM

Can someone help me with a formula to convert a column of 5000+ names from UPPER to LOWER case.....

It is a list of Real Office anmes so hopefullly leaving the first letter of each Capitalized....

Is that possible?

Thank you!!!

Ron

res@lvcm.com


Posted by Jacob on February 07, 2002 5:45 PM

Hi

To have only the first letter capitalized use proper()

Lets say the data is in A1:A5000

Then in some col lets say B put in B1 = Proper(A1)
Then fill this down all the rows.

Copy this data and paste special|Values it over the old data in A1:A5000

HTH

Jacob