How To Use Excel PROPER Function –A Quick Guide

Proper formatting is what makes the text look more clean and neat.

Excel PROPER function can help us in capitalizing the 1st character of every word in the text, let us how to use it.

1. What is the PROPER Function?
2. What is the Syntax?
3. How to use it with an example?

1. What is the PROPER Function?

The Proper function can be used to capitalize the first character of every word in the supplied text ignoring numbers and punctuations.


2. What is the Syntax?

=PROPER(text)

  • text  = (Required) Text that we want to convert to proper case.

Note :

  • Any numbers or punctuations available in the text are ignored

3. How to use it with an example?

Suppose we have to convert some existing data to the PROPER case

let’s see how to do that…!!!

Excel Proper Function

**Explained**

=PROPER(B1)
  • B1 = Reference to the cell ,which we want to convert to PROPER case.

 

Hope it has helped you… 

Advertisements

Author: Sharath Raju

Founder@www.ExcelCult.com

Leave a Reply