Finding * in formulas (XP/SP2)

Topic

New Reply

How can one find *2 (meaning times 2) in a formula. * is the wild card, so I get all cells with 2 in them.

Thanks!!!

Reply | Quote

Replies

I’m using Excel 97, but my Find dialog box includes a check box labeled “Find entire cells only”. Check that box and see if you can get what you need.

Reply | Quote

I figured it out. All you have to do is put =*2 in the find box. But that brings up another problem: How do you find cells containing any multiplier (ones that have =*anynumber).

??

Reply | Quote

Search for

~*

that is a tilde followed by the asterisk.

You can use the same approach to find a ? (~?) or indeeed a tilde (~~)

Andrew C

Reply | Quote

That’s it!

Thanks!!!!

Reply | Quote