Replace an asterix

D

Daniel

Hi

I have a spread sheet where several items are
preceded by an *.
I need to remove them, I tried "replace with" but everything I tried removed
all data, I guess because * means any words.
Any ideas on how I can replace the * automatically.

thanks

Daniel
 
B

Bob Phillips

Hi Daniel,

Try ~* in the find field.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
T

Trevor Shuttleworth

Daniel

try replacing ~* with whatever character hyou want

Regards

Trevor
 
A

Andy Pope

Hi,

Help says:
You can find asterisks, question marks, and tilde characters (~) in
worksheet data by preceding them with a tilde character in the Find what
box. For example, to find data that contains "?", you would type ~? as
your search criteria.

Cheers
Andy
 
Top