MrExcel Publishing
Your One Stop for Excel Tips & Solutions

converting text from UPPER CASE to Proper Text


Posted by Steve Main on February 04, 2002 11:45 AM

I have been pulling my hair out trying to figure out how to do this. I have a worksheet with several colunms of text that are all in upper case and I want to change all the cells in each column to proper text. How do I do this?


Posted by Scott on February 04, 2002 11:49 AM

=PROPER(A1) EOM