Excel Text 2 of 4: Change Case

Changing case is easily accomplished using Excel’s text functions.

Text 2-UpperCase10fps
Click to enlarge image
UPPER convert to upper case =UPPER(“Kanye”) returns KANYE
LOWER convert to lowercase =LOWER(“KIM”) returns kim
PROPER convert 1st  letter of each word to uppercase =PROPER(“north west”) returns North West

Convert Text to Uppercase

  1. In a blank cell enter =UPPER( text ), where text refers to the cell containing text to reformat. A copy is created in uppercase.
  2. Select the newly created copy and press CTRL+C (Copy).
  3. Select original cell.
  4. RIGHT+CLICK and select PASTE VALUES.

For 45 second video, click here:

Cheers!

hɔuᴉnb

Additional reading:

Advertisements

Author: quincy harley jr

Quincy is a technophile, coach and Learning Development expert. He has an extensive legal IT background and is practiced in MS Office application support and product development. As a project leader he has been integral in numerous new application rollouts. Whatever spare time he has, is spent with reading, archery and watching his young sons grow.

3 thoughts on “Excel Text 2 of 4: Change Case”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s