You need to let Excel know that the * is not to be used as a wildcard..a
tilde (~) is used for that.

Try this:

From the Excel main menu:
<edit<replace
Find what: ~*
Replace with: (enter your replacement text here...or leave it blank)
Click the [OK] button

All asterisks will be replaced.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Roger" wrote:

When I tried this the logical way it replaced everything..

thanks in advance.