Excel: How to capitalize the first letter of the cell
Today I had a problem with my Excel file. The file contained text converted by PROPER() Excel function which capitalizes every word in the sentence. So As You Can Imagine The Text Looked Pretty Ugly. If I were to make it all-upper-case or all-lower-case, it sould take me 1 minute to process the text with either UPPER() or LOWER(). However, I needed to capitalize the first letter of each cell only.
Here’s a great solution I found on eggheadcafe:
=UPPER(LEFT(A1,1))&LOWER(RIGHT(A1,LEN(A1)-1))
It makes UPPER() for the first letter of the cell and makes LOWER() for the rest. Mind the acronyms like XML or USSR as they will get converted to xml and ussr as well.
