How to remove a wildcard character from text column?

S

Stace Cameron

How does one remove a wildcard character from a text string?
In this case the text contains an asterisk followed by a slash. */
 
R

RagDyer

If you're talking about "Edit - Replace",
Precede the asterisk with the tilde ( ~* ) in the "FindWhat" box.
--

HTH,

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

How does one remove a wildcard character from a text string?
In this case the text contains an asterisk followed by a slash. */
 
G

Guest

Use the Substitute Function in another cell, select the text, type in "*/"
for the text to be replaced and "" for the new text. Copy and paste value
back into the original cell.
 
M

Myrna Larson

In Excel, there's no option in the Find/Replace dialogs to disable wildcards.
Maybe you are thinking of Word?
 

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 do I remove * from text string in cell 1
How to Find/Replace * (asterisk) in cell content 4
Find * 1
Use of Wildcard characters with replace 2
Find/Replace MSWord wildcard characters from within Excel 6
wildcards in formulas 1
Replacing using a wildcard 2
conditional formatting with asterisk 6

Top