Frequency Count for Top 10 Words

Do you need to know the top 10 words used in a column of your worksheet? This tip provides two methods you can use to get both the words and the counts of those words.

Read this tip »

(Thanks to Brian Dorey, Michael Avidan (MVP), Thomas Reeves, and Ryszard Raciborski for contributing to this tip.)

Unwanted Hyperlinks

Tired of having Excel convert what you type into active hyperlinks? Here are things you can do to undo Excel's conversions or stop them from happening in the first place.

Read this tip »

Formatting Made Powerful

Discover one of the foundational building blocks of Excel. Custom formats are the basis for all cell-level formatting in Excel, and you can master their use. Display your data exactly and precisely as you want.

Segregating Numbers According to Their Sign

Remember your number line from your early years in school? Some numbers can be below zero (negative numbers) and others above (positive numbers). If you want to separate numbers based on their sign, there are a few ways you can approach the task.

Read this tip »

(Thanks to James Woolley for contributing to this tip.)

Running a Macro when a Worksheet is Deactivated

When you change from one worksheet to another, you may want to have Excel automatically run a macro for the worksheet you are leaving. You can easily create such a macro by using the Auto_Deactivate event.

Read this tip »

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.

Returning the Final Word

I have a cell (A1) that contains a sentence. I need a formula that will return the last word in the sentence. I thought I had the formula, but it also considers the punctuation after the last word as part of the word. Is there a way, in a formula, to return just the last word?
—Nathan Morris (provide an answer for this Help Wanted question)