Convert text to Initial-Case (Capitalizes the first letter in Text) in Excel

PROPER function
Capitalizes the first letter and any other letters in text that follow any character other than a letter in a text string. Converts all other letters in lowercase.


The PROPER function syntax has the following arguments:

  • Text    Required. Text enclosed in quotation marks, a formula that returns text, or a reference to a cell containing the text you want to partially capitalize.


Type your data in C3 cell

and then type the proper function in cell G3

Here is the result

No comments:

Post a Comment

Recommended for You


Related Posts Plugin for WordPress, Blogger...