Replacing all asterisks in Excel 2003 spreadsheet
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
On Aug 20, 2:39*pm, JoeP wrote:
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.
|