Are you looking for one (or many) instance(s) of t *? Where in the data?
Examples.

--
Don Guillett
SalesAid Software

"Rianne" wrote in message
...
I'm trying to write a formula that will locate an asterisk (*) in a large
range of data, and if it is found, put a statement like "Hey, I found an
asterisk!" in one cell. I can't seem to get my head around the formula,
asn
I've only been able to replicate what I want by using multiple IF
statements.
I have over 200 cells that could have the asterisk in it. Please help, it
would be greatly appreciated.