Removing Asterisks from the contents of a cell

S

StarRider

Any ideas on how I can remove asterisks from the contents of a cell. Knowing
the Asterisk is a wild card and does not behave like other characters when
using "Find & Replace"
 
T

Tom Hayakawa

Use a tilde (the key to the left of the 1 on most keyboards) in front of the
asterisk, like so: ~*
That tips off Excel that you really want to deal with the asterisk as a
character and not a wild card.

Good luck.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top