One way
=IF(ISNUMBER(FIND("Z",A1)),"one thing","something else")
Regards,
Peo Sjoblom
"Matt" wrote:
I would like to be able to search a cell for a certain "character" and if it
contains that character, I would like another cell to say one thing and if it
does not contain the Character I am looking for, the cell will say something
else.
I hope this says enough.
|