Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
Find text string in column?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find certain text in a column and return statement | Excel Worksheet Functions | |||
Search a Column by text length | Excel Worksheet Functions | |||
another text to column problem | Excel Worksheet Functions | |||
need to find which numbers (3+) in a column sum to a value | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |