Forum Discussion

Copper Contributor

Mar 25, 2022

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 capita...

excel

Formulas and Functions

Macros and VBA

Starrysky1988
Mar 26, 2022
Here is the answer.
=Upper(Mid(A1,1,1))&Mid(A1,2,Len(A1))

Starrysky1988

Iron Contributor

Mar 26, 2022

Here is the answer.
=Upper(Mid(A1,1,1))&Mid(A1,2,Len(A1))

akesserwani
Copper Contributor
Mar 28, 2022
How can I learn the logic behind this formula and other formulas as well? What excel training should I get?
- Starrysky1988
  Iron Contributor
  Mar 28, 2022
  akesserwani
  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.
  - akesserwani
    Copper Contributor
    May 03, 2022
    Are you able to provide further into to my second question below please?
    
    I tried it but still couldn't get this as a result "=Upper(Mid(A1,1,1))&Mid(A1,2,Len(A1))". In the question I wrote capitalize first word only..etc but it was only giving me the proper function, even if i press help on this function.
    
    Thanks.