Search and replace problem

[Melissa]

Hi,

I have an Excel worksheets where in several cell's a symbol was added to
mark the cell's "to review".

The symbol used was "(*)".

I have tried now to delete all the entries with a "search and replace", but
Excel interpretes the asterisk as a DOS-symbol and deletes everythng between
brackets.

Is there a way to avoid that or to let Excel know that I only want to delete
the specific characters.

TIA

Melissa

 

[Peo Sjoblom]

It's because it is a wildcard, you can replace it by preceding it with a
tilde ~ which tell Excel to find an asterisk

in find what put ~* then replace with nothing (I assume you want to remove
it since you said delete so do not put anything in the replace with box)


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com

 

[Melissa]

It's because it is a wildcard, you can replace it by preceding it with a
tilde ~ which tell Excel to find an asterisk

in find what put ~* then replace with nothing (I assume you want to remove
it since you said delete so do not put anything in the replace with box)

Thanks,

Melissa


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com