You could use a formula like:
=isnumber(search("account",a1))
and drag down the column.
True means it found it. False means nope.
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
|