Thank You

Last week I mentioned that my middle son was getting married,and many of you responded by wishing the newlyweds well. Speaking on behalf of my family, I appreciate your kind remarks and wishes. They were very warmly received.

I hope that you enjoy the tips in this week's newsletter.

—Allen
     

ExcelTips (ribbon) for 25 June 2016

Cell formatting
Converting Dates to Text

Need to use a date as part of a larger string of text? Here are some handy ways to go about the process.

Read this tip »

(Thanks to Steve Aprahamian, Tony Greaves, Jim Williams, Elliot Penna, Steve Lindquist, Ira Bernstein, Erik Oberg, Fabio Gambaro, Mike Shellito, Ron Solecki, Val Almosnino, Kara Lynn, Kevin Weston, Philip Planchenault, Chris Watt, Rolf Pedersen, Alex Guzman, Bob Beechey, Ronald Doeleman, Richard Berry, David Shepherd, Damian Fennelly, George Stowe, Carole Haley, Steve Viney, Robert Danchisko, Amy Harris, Pippa Jones, Anne Maloney, and David Gray for contributing to this tip.)

 
Formatting worksheets
Centering Your Worksheet

Got just a small amount of worksheet data to print out? It might look better on the printed page if you center it. Excel makes it easy, both vertically and horizontally.

Read this tip »

 
Enhance Your Excel Skills with Macros

Macros are a great way to increase your productivity with Excel by making the program work the way you want it to work. Discover the true power behind macros; ExcelTips: The Macros puts almost 800 pages of macro-focused information at your fingertips. Discover more...

 
Formulas
Extracting First and Last Words

When working with text phrases stored in cells, it might be helpful to be able to extract words from the phrase. In this tip you discover easy ways to access both the first and last words of such a phrase.

Read this tip »

(Thanks to Mickey Avidan and David de Jongh for contributing to this tip.)

 
Comments
Printing Comments

Comments can be a boon when you want to annotate your worksheets. If you want, you can instruct Excel to print the comments right along with the worksheet itself. Here's how to instruct Excel to include them.

Read this tip »

     

Help Wanted

This section is for those having problems making Excel behave. If Excel is giving you fits, feel free to submit your own Help Wanted question.

If you have a solution for the problems below, click the link after the problem to send us your answer. (All responses become the sole property of Sharon Parq Associates, Inc., and can be used in any way deemed appropriate.) If your response is used in a future issue, you will be credited for your contribution to the answer.

 
Changing Number Display Settings for Single Workbooks

I am a Canadian Excel user who often downloads large amounts of statistical data from European sources, thereby experiencing the usual problems with decimals and thousands separators being reversed. This requires some fancy manipulation to change to North American style and often results in mistakes. I could change the settings on my entire system, but then my North American numbers (in other workbooks) are screwed up. Is there some way to change just one file at a time?
—Allen Hingston (provide an answer for this Help Wanted question)

 
ExcelTips is a free service of Sharon Parq Associates. You can find thousands of tips at our website and a whole lot more. ExcelTips is part of the Tips.Net network.
Sharon Parq Associates, Inc.  •  PO Box 794  •  Orem, UT  84059  •  801-607-2035