Calculating Domains and Counts

If you need to pull domain names from a lot of email addresses, then you'll appreciate this tip. It covers several formulaic approaches and a handy macro.

Read this tip »

(Thanks to Brian Dorey, Alan Cannon, Kevin Keyser, Ken Kast, Leslie Glasser, Dick Downey, James Woolley, Rick Rothstein, and Jacques Raubenheimer for contributing to this tip.)

Out of Memory Errors for Macros

Tracking down memory errors in a macro can be frustrating. The error message is inherently vague and correcting any errors may involve a lot of trial and error. This tip focuses on a few things you can check out if you have this type of error.

Read this tip »

Are You Foundering at Filtering?

We have all experienced the frustration inherent with using Excel filters. Stop foundering when filtering your data by getting your copy of ExcelTips: Filters and Filtering today. More info available online.

Counting Asterisks in a Column

Excel can be used as a simple database program. If you use asterisks in a column of your database to designate ranking of each row, then you may need a way to count how many "asterisk rankings" of each type you've used. Here are several different formulas to get the results you want.

Read this tip »

Jumping to the Real Last Cell

Jumping to the last cell in a worksheet should be easy, but you may not always get the results that you expect. This tip looks at why this could be the case and how you can get around the problem.

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.

Special Pasting in a Single Click

In Excel 2007, there is an icon to paste values that looks like a clipboard with the #12 on it (I paste pictures from Publisher). In Excel 2019, to get the same results, I need to paste as Picture: Enhanced Metafile, which means two extra steps: I have to go to the Paste icon, then Paste Special, then select Enhanced Metafile. Is there a way to create the Enhanced Metafile option in one click?
—Brooke Samples (provide an answer for this Help Wanted question)