View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Topmark Topmark is offline
external usenet poster
 
Posts: 2
Default 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