With the Excel function PROPER you get capitalized initial letter in every word in a text string.

The text on row 2 is changed by the Excel "PROPER" - function

The text on row 2 is changed by the Excel “PROPER” – function

 

The image is showing the formula in cell B2 that capitalize all initial letters in the text string in A2.

The image is showing the formula in cell B2 that capitalize all initial letters in the text string in A2.


Leave a Reply

Your email address will not be published. Required fields are marked *