This will extract the name before (ace)

=MID(A1,1,((FIND(" ",A1,1)-1)))


edvwvw

puiuluipui wrote:
Stefi, can you help me with one last problem? at least i hope so....
It's about date formula...
=IF(VLOOKUP(A1;PLANNING!B:C;2;FALSE)=TEXT(B5;"ddd d");"YES";"NO")

Example:

a b c
planning! b c
1 john (ace) 11.05.2008 no john
monday
2 mary (mer) 16.05.2008 yes mary
friday

i would like formula to ignore parenthesis " (ace) ; (mer) "
in my table i will write like this :john (ace) and mary (mer), but in
database it will be without parenthesis : "john ; mary"... Can formula
extract only john or mary? ..and ignore the rest?

it is posible?

THANKS ALLOT

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200805/1