Actually, what i meant is that i have over 30 values in column a that i want
to replace in column b if indeed it is in column a. IE, the formula might
look like this =IF(ISNUMBER(SEARCH("general","general2", "general3",
A1)),"general","") is that possible and if so how exactly should the formula
look?
thank you!!
Hudini

"Ragdyer" wrote:

By "Copy down as needed", I meant ... with values in A1 to A30,
After entering the formula in B1,
Click back in B1 to select it.

In the lower right corner of the selected B1, you'll see a tiny black
square.
Hover your cursor over this square until the cursor changes from a fat white
cross to a skinny black cross -
THEN - click and drag down to B30.
This will cause the formula to copy itself down Column B, changing the
relative cell references in the formula, dependant on the row it's copied
to.

Another copy approach (*if* A1 to A30 contain *no* empty cells),
is to *double* click on that tiny black square in B1,
which will automatically copy the formula in B1 as far down Column B as
there is data in Column A.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"hudini" wrote in message
...

Thanks RD that was very helpful! any ideas if i have to do this over 30
times? ie there are 30 values in row A that i want to extract and input
correctly in Row B.
Thanks again!
Hudini



"Ragdyer" wrote:

Try this in B1, and copy down as needed:

=IF(ISNUMBER(SEARCH("general",A1)),"general","")

--
HTH,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-
"hudini" wrote in message
...
Hi there,
i am trying to extract a value from a column that contains multiple
'selections' separated by a ';" sign. Ie in Column A i want to find
every
value 'general' and input that value in column B the same row. Any
formulas?
thanks so much!
Hudini