## Usage Of PROPER Function In Excel

Basically, Proper function is a built-in function in Excel which can be considered as a string or text conversion function like Upper & Lower function. Generally, it only capitalize the first letter of a word in a given text string and the return value will be considered as proper case.

N.B. If you are unsure about the process of UPPER & Lower function in Excel, then please check below URL’s first, which will give you a clear concept about the working principle of these sorts of functions.

URL: http://www.tutorialabc.com/2020/09/lower-function-in-excel.html

Basic Syntax

 =PROPER(text)

It passes a single argument, “text” – which text will be converted to proper case.

Notes: This function can be available from Excel 2000 to up-to-date version of Excel. And, Proper function will not consider - Spaces, numbers and punctuation marks.

Example:

Let’s consider, we have a sample set of data in the worksheet.

 (Working Data)

We will get the result, by using the PROPER function, ‘=PROPER(A1)’

Result: James Bond

And, ‘=PROPER(A2)’

Result: Hello! World

So, to get the exact result, please take a closer look on the below screenshots and follow along with the sequence. Hopefully, it will help you to understand the PROPER function in excel properly.

 (PROPER function syntax)

 (Proper Case)

 (Conditions Unaffected)

For any query or suggestions, feel free to contact us and stay with tutorialabc.com for more Excel-based contents.

## Usage Of LOWER Function In Excel

LOWER function in Excel works in a similar manner of UPPER function but it will do the opposite process of UPPER function. In brief, The LOWER function returns a lower case format of a given text. If you are unsure about the process of UPPER function then please check below URL first, which will give you a clear concept about the working principle of these sort of functions.

Basic Syntax
 =LOWER(text)

It passes a single argument, “text” – which text will be converted to lower case.

Example

Suppose, you have a wide range of text in a spreadsheet which are in upper case or in some different format which give you a little bit disturbance to resolve your project with Excel. In that case, you may try to use the LOWER function to sort out the problem.

But, keep in mind that - Spaces, numbers and punctuation will be unaffected in LOWER function.

For the demonstration, we use some upper case text including space, number and punctuation markup and finally, we will get the lower case version of those text using LOWER function.

So, please take a closer look on the below screenshots and follow along with the sequence. Hopefully, it will help you to understand the LOWER function in excel properly.

 (Working Data)

 (LOWER function Syntax)

Soon, we will provide a similar type of tutorial known as PROPER function in Excel and till then keep learning and stay with tutorialabc.com! For any query or suggestions, feel free to contact

## Usage of UPPER function in Excel

UPPER function in excel converts a given text into an upper case version. But, it will not affect on any numbers or punctuation marks at all. This function will help you to sort out a spreadsheet where most of the text entries are in lowercase. By using, UPPER function you can simply and very quickly resolve the issue.

Basic Syntax
 =UPPER(text)

It passes a single argument, “text” – which text will be converted to upper case.

Example
Suppose, you have a wide range of text in a spreadsheet which are in lower case format and you want to convert those texts into upper case. Also, have a number value and punctuation and you want to use UPPER function to look at the differences.

“john”, “doe”, “9871”, “Hi!” are some values in a your spreadsheet. Now, follow the below image sequences and try it out by yourself. Hopefully, it will help you to understand the UPPER function in excel properly.

 (Sample Data)

 (Writing UPPER function)

 (Selecting text from the cell)

 (After converted to upper case)

 (Ignoring numbers & punctuation)

Next, we will provide a tutorial on LOWER function in Excel and till then keep learning and stay with tutorialabc.com! For any query, feel free to contact us.