How to capitalize the first letter in a text string in Excel
Posted: Mon Mar 13, 2017 8:11 pm
Excel has a function that capitalizes the first letter in each word:
=PROPER(text)
Let's see the following example. Enter in cell B1
=PROPER(A1)
You may copy it down the column for the rest text strings.
=PROPER(text)
Let's see the following example. Enter in cell B1
=PROPER(A1)
You may copy it down the column for the rest text strings.