How do I search for an asterisk in an Excel file--it thinks the a.
 

I'm trying to replace an asterisk that appears multiple times in an Excel
file. When I try to do this, Excel thinks everything applies because the
asterisk is the wildcard. I've tried "Match entire cell contents."

Hi, ace.
Search for:
~*

tj

"ace" wrote:

I'm trying to replace an asterisk that appears multiple times in an Excel
file. When I try to do this, Excel thinks everything applies because the
asterisk is the wildcard. I've tried "Match entire cell contents."

Use ~* in the find.

Greg
"ace" wrote in message
...
I'm trying to replace an asterisk that appears multiple times in an Excel
file. When I try to do this, Excel thinks everything applies because the
asterisk is the wildcard. I've tried "Match entire cell contents."

Wildcards should be preceded by a tilde ~

Regards

Peo Sjoblom

"ace" wrote:

I'm trying to replace an asterisk that appears multiple times in an Excel
file. When I try to do this, Excel thinks everything applies because the
asterisk is the wildcard. I've tried "Match entire cell contents."