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
