Finding an asterisk in a cell

[ostate2007]

When I try to find an asterisk (*) in a celly using Find, it return
every cell because the asterisk is used as a 'wild card'. When I us
quotations around it, "*" it will not find the cell. Is there anywa
to do this as I am trying to impliment it into a macro. Thank you.

-Brando

 

[Bearacade]

Put in ~*

This is going to find all formulas with a * in it too thoug

 

[somethinglikeant]

Precede with tilde ~*

somethinglikeant

 

[ostate2007]

No problem with formulas. Thanks!

-Brando

 

[Nikki]

find ~*

click options--> look in value will find you just the value and not formula