Simple Search and Replace Question

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

Guest

Hi. I am searching and replacing various characters in an Excel column. I
need to delete all the asterisks (*) in this column. How do I do this? That
is, how do I make Excel "think" the asterisk is NOT a wildcard characteer but
a real character that I want to get rid of?
 
Rebecca said:
Hi. I am searching and replacing various characters in an Excel column. I
need to delete all the asterisks (*) in this column. How do I do this? That
is, how do I make Excel "think" the asterisk is NOT a wildcard characteer but
a real character that I want to get rid of?
Click to expand...

Find What: ~*

instead of just: *
 
Rebecca

Prefix with a single tilde (~) so you will have ~* to find the *

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 

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

How to Find/Replace * (asterisk) in cell content 4
Find * 1
Find Last Instance of "Text" in a column 5
wildcards in formulas 1
Globally replacing * 2
Use of Wildcard characters with replace 2
How do I search for an asterisk in an Excel file--it thinks the a. 3
How can I add a character to the end of every row in Excel 2000? 6

Back
Top