Seems like that was too easy for you. And it worked, too. Thanks. How
about this one...The data is coming from another database pulled with an ODBC
connection. The cell shows that Excel merged the data into one cell (in the
other app, someone hit 'enter' to break the data on two lines). Excel shows
it in one cell but with a, for lack of a better term, and small box in
between the two words. I want to keep it in one cell, but get rid of that
little box. Do you know how to do that? Does that even make sense?

"Chip Pearson" wrote:

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?