Precede the * with a ~, e.g., ~*


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Wildcard" wrote in message
...
I have data in a the workbook that contains an asterik in it. I
want to
clear that character and leave the remaining ones (or replace
it with
something). But a * is considered a wildcard character that
signals Excel to
grab everything. How do I find and replace just that?