How to Find/Replace * (asterisk) in cell content

[Topmark]

I need to clean up the entries in a description column in Excel. The problem
is that I need to find and replace each occurrence of an asterisk (*) in
these descriptions. Since * happens to be the wildcard character,
find/replace returns every cell in this list of 14,000 items and I know that
there are hundreds of occurrences that I need to replace.

How do you search for the wildcard * and replace it?

Any help will be appreciated.

Thanks

 

[Mike H]

Hi,

Put a tilde ~ in front of the asterix in the search box and it will treat it
a as a literal character instead of a wildcard

Mike

 

[muddan madhu]

try this

=SUBSTITUTE(A1,"*","")

 

[Topmark]

Thanks for the quick response, the tilde did the trick.

 

[Mike H]

Glad I could help

Thanks for the quick response, the tilde did the trick.