Searching trick?

B

Bill

I am trying to search for a string from an imported file.
The lead character in the string is the * character. Of
course, if I do a search in Excel like '*', it finds
everything. How can I get it to treat * like a character
and not a wild card??
 
D

David McRitchie

Hi Bill,
prefix it with a tilde (~) as ~*

Escape characters in formats use a backslash, in Find/Replace use a tilde.
to search for * or ? or ~, you enter it as ~*, ~? and ~~, respectively.
In headers and footers to see an ampersand (&) double them as in
AT&&T. Double quotes within double quotes are doubled.
 
Top