replace using *

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Excel 2002. I have a column that contains text. Within this text
are multiple *. I would like to replace them with nothing using the find and
replace option. The problem is when I put the * in the find filed Excel
assumes it is a wild card and replaces the entire field with blank. How do I
tell Excel the * is not a wild card but an actual character.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find and Replace Command Using Wildcard Help 1
Second last character incrematation 2
Eliminate wild characters 5
Mass Changes in Excel using Wild Cards or other 3
The Witcher 3 upgrade 4
Windows 10 I would like to know in a batch file how to indentify computer name by using the first 5 of the name and the last 2 of the name then call runcmd 0
Find Replace takes forever 1
Find and Replace variable string 11

Back
Top