How to remove a wildcard character from text column?

  • Thread starter Thread starter Stace Cameron
  • Start date Start date
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. */
 
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. */
 
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.
 
In Excel, there's no option in the Find/Replace dialogs to disable wildcards.
Maybe you are thinking of Word?
 
Back
Top