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
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