Forum Discussion
Solved
Capitalize the first letter of a word only! in a sentence
How to capitalize the first letter of the first word ONLY!! in a sentence that contains other words with small and large letters too but they should be left un touched. We only want to replace capitalizing the first word, without altering the rest of the sentence from what it already is.
- Here is the answer.
=Upper(Mid(A1,1,1))&Mid(A1,2,Len(A1))
9 Replies
- Here is the answer.
=Upper(Mid(A1,1,1))&Mid(A1,2,Len(A1))- How can I learn the logic behind this formula and other formulas as well? What excel training should I get?
You can just learn it by using Excel.
Type any function in the formula bar and press "fx" button in front of the formula bar. And then press help on this function.
