Searching trick?

[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??

 

[Ron de Bruin]

Use this in the Find dialog Bill

~*

 

[Ken Wright]

Precede with a tilde ~*

 

[Frank Kabel]

Hi
search for ~*

 

[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.