Change The Case Of Text In Word-But Not In Excel

BY STANLEY ZAROWIN

Q. Is there some fast and easy way to change the case of text in Word and Excel?

A. You can in Word, but although many users desperately wish they could do it in Excel, I’m sorry to say, they can’t yet. I’ve seen some very complex macros written that are supposed to be effective, but none that I’ve tried works very well.

In Word, case changing is a snap. One way is to put the Change Case icon on your toolbar. To do that, click on Tools , Customize , click on the Commands tab, go to Format and then scroll down to Change Case . If you keep moving down, you’ll notice another Change Case icon: Next to it is an icon with three letter A s.

They both can do the job, but they do it in slightly different ways. Drag either the first Change Case or the triple A icon up to your toolbar.

If you choose Change Case , highlight the target text and click on Change Case ; the highlighted text will toggle among upper case, lower case, title case and sentence case. But if you select the triple As, this screen will pop up:

There still is one more way: After highlighting the target text, press Shift+F3; each time you press those buttons, it toggles the text among upper, lower and title case. It doesn’t do sentence case unless the highlighted text contains a period or semicolon.

SPONSORED REPORT

Revenue recognition: A complex effort

Implementing the new standard requires careful judgment. Learn how to make significant accounting judgments and document them and collaborate with peers for consistent application.

VIDEO

How to Excel pivot a general ledger

The general ledger is a vast historical data archive of your company's financial activities, including revenue, expenses, adjustments, and account balances. J. Carlton Collins, CPA, shows how to prepare data for, and mine data with, PivotTables.

QUIZ

News quiz: Taking an economic snapshot and looking to the future

Recent news included IRS actions that affect individuals and partnerships and a possibly influential move by a Big Four accounting firm.Take this short quiz to see how much you know about the news.