How to Capitalizes first letter of text in Microsoft Excel / Use of PROPER function/formula in Microsoft Excel



PROPER


Use of PROPER Function/Formula in Microsoft Excel:


This function/formula capitalizes the first letter in particular cell
and any other letters in text that follow any character other than a letter. Convert all other letters to 
lowercase letters.



Syntax/Formula :

The syntax of PROPER in Microsoft Excel is below.

=PROPER(?


Example :

Step 1: First type advanced ms excel.blogspot.com in cell B4 as per shown in below image.

Step 2: Type formula =PROPER(B4) in cell B6 and press enter.


PROPER


No comments:

Post a Comment