Find and Replace char '*'

General discussions about Advanced Find and Replace
Post Reply
Posts: 2
Joined: Fri Aug 19, 2005 8:20 am

Find and Replace char '*'

Post by toco » Fri Aug 19, 2005 8:23 am

Is there a way to replace the character '*' in Excel 2003 with "Advanced Find and Replace" ?

Posts: 7
Joined: Mon Jul 11, 2005 10:34 pm

Post by Darwin » Sat Aug 20, 2005 8:54 pm


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.


Site Admin
Posts: 1220
Joined: Mon Jan 31, 2005 5:32 pm

Post by Abacre » Sat Aug 20, 2005 9:44 pm

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.
Kind regards,
Abacre Limited

Posts: 2
Joined: Fri Aug 19, 2005 8:20 am

Replace '*' in Excel 2003

Post by toco » Sun Aug 21, 2005 4:11 am

Thaks, I'll wait to try this fix.


Post Reply