Page 1 of 1

Find and Replace char '*'

Posted: Fri Aug 19, 2005 8:23 am
by toco
Is there a way to replace the character '*' in Excel 2003 with "Advanced Find and Replace" ?

Posted: Sat Aug 20, 2005 8:54 pm
by Darwin

I haven't tried this with AFR myself, but usually if you want to search/replace symbols like ? and *, you need to put a tilde (~) in front of them: ~* or ~?.

I don't know if this will work in a replacement but it certainly works when you are searching.


Posted: Sat Aug 20, 2005 9:44 pm
by Abacre
Just to let you know:
you should normally use search for *
and replace with desired char.
But we found some issue for replacing in MS Excel files (occurring
only in the latest version of the program). It will be fixed next week.

Replace '*' in Excel 2003

Posted: Sun Aug 21, 2005 4:11 am
by toco
Thaks, I'll wait to try this fix.