MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Replace '*' character NOT meaning wildcard

Posted by Susan on April 18, 2001 3:18 PM

I know I've done this before but am having trouble now...

I want to delete a section of a formula (in 500+ rows) which includes the asterisk * character, but the Edit-Replace is treating the * as a wild card and deleting virtually the entire formula. Anyone?

Posted by Ian on April 18, 2001 3:23 PM

To identify the asterick as non-wildcard, proceed it with a the tilde above the single quote key.

Posted by Paul H. on April 18, 2001 8:19 PM

This is one tip I'm very glad to get! I've also had fits with removing asterisks.


Paul H.