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

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

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

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

"Topmark" wrote:

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

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

try this

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


On Oct 23, 9:22*pm, Topmark wrote:
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

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

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

"Mike H" wrote:

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

"Topmark" wrote:

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

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

Glad I could help

"Topmark" wrote:

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

"Mike H" wrote:

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

"Topmark" wrote:

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