Find text string in column?

[none]

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]

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

[Dave O]

If you want to search in column A, for instance, copy this formula into
cell B1
=IF(FIND("Account",A1,1)>0,TRUE,FALSE)
and copy it to remaining cells in column A.

[Dave Peterson]

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