And one of the differences between DaveO's response and mine is that I used
=search() and DaveO used =Find().
=search() is not case sensitive Account, ACCouNT, AccoUnt, account would all be
accounted for <bg.
DaveO used =find(). That is case sensitive. He'll only find Account.
What you use will depend on what you really want.
none wrote:
I need a formula to search through a column and find the text "ACCOUNT".
Possibly print TRUE in the adjacent column.
Any help is greatly appreciated.
Greg
--
Dave Peterson
|