#409 Quick & Easy Way To Change Text Case in Excel

The data you work with in your spreadsheets can come from a variety of sources. If you’re lucky everything is nice and consistent….but often its not.  Some cells are in ALL CAPS, some are all lowercase and some are even a jumbled mess of both.  You definitely can’t show that ugly stuff to your boss or your customers, so what can you do? Before you jump head first into manually editing it, or even worse retyping your data; you need to know these handy Excel formulats that can handle that job for you.

Let’s take a look at this sample spreadsheet.

Original

Ugly right?!  No problem here are the Excel formulas you can use to change the text and use whatever case you want.

Formulas

In a blank ‘helper’ column enter one of these formulas. Now you have two columns with the same data. Just copy the data from  your ‘helper’ column and paste them over the original data using Paste Special » Values.  Then delete your ‘helper’ column and now you’ve got time for a cup of coffee from all the time you just saved!

After

Word Documents Too!

If you ever need to do the same thing in a document, it is even easier in Word. Just select your text and use the ribbon to select what type of case you want.  Couldn’t be any easier!

ChangeCase-Word

Advertisements

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