Excel Tutorial: Text Editing with LOWER, UPPER and PROPER Functions

When text is imported into EXCEL the format may need editing to match the style of the EXCEL table. The following functions can adjust text lower and upper case to unify text formatting.

 

The LOWER function returns all text as lower case:

= LOWER(text)

 

The UPPER function returns all text as upper case:

= UPPER (text)

 

The PROPER function returns text with the first letter of each word as upper case and the rest of the letters in each word as lower case:

= PROPER(text)

 

The following example shows the return result of the UPPER, LOWER and PROPER functions on a string of text with various upper and lower case letters. These functions are powerful at manipulating text to quickly and easily format inputted text that may have lower and upper case errors.


We teach most of these functions in our Basic Excel Course or our Advanced Excel Training

Download spreadsheet example here

Hector Garcia CPA and QuickBooks/Excel Trainer

Hector Garcia CPA and QuickBooks/Excel Trainer

Use our link to get 30% off for a year, valid through 07/31/2022

Popular Courses

Private QuickBooks Training onsite

Customized Training

Accounting & Bookkeeping Services

Video-Based Virtual QuickBooks Course

Share

30% Off QuickBooks

Use our link to get 30% off for a year, valid through 07/31/2022