If you’d like to capitalize all letters in a cell, it’s easy – just use the following formula (assuming cell “A1″ has the text you want to capitalize).
But what if you just want to capitalize the first word in the cell “A1″? For example, you have the following text in a cell “A1″ and you’d like to capitalize just the first letter:
“How to Get a High School Diploma in 1 Day”
To capitalize “How” in cell “A1″, use the following formula:
“How to get a high school diploma in 1 day”
Not working for you?
Remember to replace “A1″ with the cell that contains the string of words you want to parse out.