Find&Replace * - Is it possible to treat * as text and not wildcar

G

Guest

The contents of my spreadsheet have an * at the beginning of the text in
several of the cells (i.e. *Doe, John). When I attempt to do a Find&Replace
specifying "*" as the find and "" as the replace, it simply wipes out
everything. Is it possible to specify * as text and not as a wildcard? Or
is it possible to create a macro that does the same thing? Any
suggestions/hints, etc. would be greatly appreciated.

Thanks,

Steve Stringham
 
R

RagDyer

Try this in the Find box:

~*

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

The contents of my spreadsheet have an * at the beginning of the text in
several of the cells (i.e. *Doe, John). When I attempt to do a Find&Replace
specifying "*" as the find and "" as the replace, it simply wipes out
everything. Is it possible to specify * as text and not as a wildcard? Or
is it possible to create a macro that does the same thing? Any
suggestions/hints, etc. would be greatly appreciated.

Thanks,

Steve Stringham
 

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

Use of Wildcard characters with replace 2
Find and Replace variable string 11
How do you find and replace unwanted symbols in text cells? 2
Why not accept wildcards for REPLACE as well as FIND ? 5
Find/Replace Numbers stored as Text drops zeros 1
"Find" a wildcard as a place marker and "replace" with original va 1
Find and Replace function not working 1
find text in cell and replace it with part of the text in that ce. 3

Top