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