Packages

Top
Site Links

Are you spending your valuable billable time working on administrative tasks? Optimize your focus by working with an experienced Virtual Assistant who will maintain order in your work life. Exemplus will provide you with the support you need so you can focus on more rewarding activites.

Friday
30Oct2009

The case for text - A MS Excel Tip

DateFriday, October 30, 2009 at 11:02AM

Have you ever wasted valuable time changing the case (upper/lower) of text in an Excel file? Then this is a shortcut many of you will love to know.

=UPPER(A2) This formula will change all of the text referenced in cell A2 to UPPERCASE
= lower(a2) This formula will change all of the text referenced in cell A2 to lowercase
=Proper(A2) This formula will change the leading letter referenced in cell A2 to Title Case

The cell that the formula is in is also the cell where the results will appear. So if you’re typing the formula “=UPPER(A2)” in cell B2, that’s where the results will appear.

Did you like this tip?

AuthorFern Carbonell | CommentPost a Comment |

PrintView Printer Friendly Version

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
All HTML will be escaped. Hyperlinks will be created for URLs automatically.
Alert
Comment Moderation Enabled
Thanks for your comment.