Simple Search and Replace Question

#1 April 3rd, 2005, 02:53 PM

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?

#2 April 3rd, 2005, 03:30 PM

Rebecca wrote:
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?

Find What: ~*

instead of just: *

#3 April 3rd, 2005, 03:33 PM

Rebecca

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"Rebecca" wrote in message
...
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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to automate multiple "search & replace" operations	Dale	General Discussion	1	July 14th, 2004 05:57 PM
how do I do a "starts with" - search & replace in excel	jrs-JCI	General Discussion	3	June 24th, 2004 08:09 PM
MASSIVE search & replace question	Ann Scharpf	General Discussion	7	June 16th, 2004 10:47 PM
search and replace individual documents	Hilary Ratner	General Discussion	5	June 10th, 2004 01:35 AM
Search and replace....	Kevin Stecyk	Worksheet Functions	5	November 4th, 2003 11:42 PM