parenthesis
 

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;"dddd ");"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

parenthesis
 

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

parenthesis
 

i want to use this formula
=IF(VLOOKUP(A1;sheet2!B:C;2;FALSE)=TEXT(B5;"dddd") ;"YES";"NO") and extract
everithing from cell a1 but without parenthesis. i will try to explain better
in my example, and how this formula works for me:



a b c sheet2! b
c

1 john 11.05.2008 no john
monday
2 mary 16.05.2008 yes mary friday
3 john 12.05.2008 yes


the formula tell me if john or mary arrive in the correct day.
the problem is thet after john, it will be one or two more words, even
numbers example : " john ed (ace)" ; "john 117 (ace)" . so i don't want to
extract the first word, i want to exclude the parenthesis. and i wont to use
the formula i used before. with a little modification...

the new table will look like this:


a b c
sheet2! b c

1 john 117 (ace) 11.05.2008 no john
monday
2 mary re (mer) 16.05.2008 yes mary
friday
3 john ed (ace) 12.05.2008 yes john
117 monday

I need to use the same formula and to write in a1 "john 117 (ace)" but the
formula to see it as john 117 and to tell me if john it's comming in the
correct day.


THANKS

"edvwvw via OfficeKB.com" a scris:

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