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

thanks in advance.

Use ~* to find/replace *
~? to find/replace ?
~~ to find/replace ~



Roger wrote:

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

thanks in advance.

--

Dave Peterson

The * and ? symbols are used as wildcard characters by Excel. To override
this function, precede the symbol with a tilde ~. So, to find/replace the *
character, type: ~*

HTH,
Elkar


"Roger" wrote:

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

thanks in advance.

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.