Replacing all asterisks in Excel 2003 spreadsheet

  • Thread starter Thread starter JoeP
  • Start date Start date
J

JoeP

I am working on a spreadsheet that I have pulled data from another source.
Some of the cells contain double asterisks ** and other cells contain the
data that I want to work with.
I wanted to eliminate the ** so I tried to Replace All the ** with a space,
but when I do this all my data disappears.
Is there a way to eliminate the ** only and not the other data?
Thanks.
 
The asterisk is a wildcard character staning for all characters.

If you want to replace an asterisk, yo must precede it with the tilde
symbol, ~

ie: Find what ~*
Replace with leave blank
Click Replace All

Hope this helps.

Pete
 
Just to add to the other replies...

If you want to replace an asterisk character, use ~* in the from string.
If you want to replace a question mark, use ~? in the from string.
If you want to replace a tilde (~), use ~~ in the from string.
 
Back
Top