• LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

Simple way to cure a case of the ALL CAPS

by on
in Office Technology

Ever receive a spreadsheet where someone entered the entire field in ALL UPPER CASE? How do you change the field to upper and lower cases?

Try this tip, recommends software whiz Jim Spellos of Meeting U (www.meeting-u.com):

Let’s say in cell A1, you have the first and last name as an all-upper-case entry: Example: JAMES BROWN. You can make the change by using a formula.

In cell B1, enter the following formula: =proper(a1)

That will return the proper case (first letter of each word caps) for that cell. If you want all lower or upper case, then it looks like this: =lower(a1) or =upper(a1)

One challenge: If you change or delete the original column (A), the new formula will change (or be removed) as well. To remedy that, once you’ve made the changes to the column, select all the newly created formulas, and hit your copy key. You’ll see those dashed lines around the text you’ve selected.

Now, don’t paste and don’t move your cursor anywhere else. Instead, paste right over this text.

Select Edit menu. Choose “Paste Special.” Select “Values” button, and then hit “OK.”

This special paste process now converts the formula =proper(a1), to that value. Now, even if you eliminate the original column one, your new information remains intact.

Like what you've read? ...Republish it and share great business tips!

Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...

We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.

The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.

" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/23674/simple-way-to-cure-a-case-of-the-all-caps "

Related Articles...

    No matches

Leave a Comment