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 capita...
- Here is the answer.
=Upper(Mid(A1,1,1))&Mid(A1,2,Len(A1))
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.
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.
- Well my initial question was answered by Starrysky, it worked. However what he suggested later, I wasn't able to figure out how to do: " 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. "Here too is a website which explains Excel functions very well.
https://exceljet.net/excel-functions
Scroll down that page to find a complete list of functions that enable the manipulation of text strings. You'll also see various categories of functions--Financial, Scientific, etc.--
Try the following:
Select a cell.
Type =MID and then press Tab.
Excel should add an opening parenthesis ( after the word Mid and show a tooltip in which the word MID is a hyperlink:
The tooltip shows the arguments of the function (here: text, start_num and num_chars). Clicking the hyperlink should open the Help pane with information about the function.
