How can i extract some text data.....
 

I am doing a special project in my work...my problem is i can find the
right command in elimininating some data from the data base provided to
me....here is the example...

Le Yuan [Jolin Tsai]
Ye Qu [Jay Chou]
Ai Mei [Rainie Yang]

I need to take out all the data in close parenthesis to match with my
data base in performing the look up function.

Here is the command i used courtesy of John Walkenback book, but my
problem is this command cant particulary identify the word in close
parenthesis only..

=IF(ISERR(FIND(" ",C24))," ",LEFT(C24,LEN(C24)-FIND(" ",C24,1)))

Thanks in advance for the help!!

How can i extract some text data.....
 

will this work for you?

=IF(ISERR(FIND("",C24))," ",LEFT(C24,FIND("[",C24,1)-2))

--


Gary


"Saz" wrote in message
oups.com...
I am doing a special project in my work...my problem is i can find the
right command in elimininating some data from the data base provided to
me....here is the example...

Le Yuan [Jolin Tsai]
Ye Qu [Jay Chou]
Ai Mei [Rainie Yang]

I need to take out all the data in close parenthesis to match with my
data base in performing the look up function.

Here is the command i used courtesy of John Walkenback book, but my
problem is this command cant particulary identify the word in close
parenthesis only..

=IF(ISERR(FIND(" ",C24))," ",LEFT(C24,LEN(C24)-FIND(" ",C24,1)))

Thanks in advance for the help!!

How can i extract some text data.....
 

or do you want the text within the brackets?

=MID(C24,FIND("[",C24,1)+1,LEN(C24)-FIND("[",C24,1)-1)

--


Gary


"Saz" wrote in message
oups.com...
I am doing a special project in my work...my problem is i can find the
right command in elimininating some data from the data base provided to
me....here is the example...

Le Yuan [Jolin Tsai]
Ye Qu [Jay Chou]
Ai Mei [Rainie Yang]

I need to take out all the data in close parenthesis to match with my
data base in performing the look up function.

Here is the command i used courtesy of John Walkenback book, but my
problem is this command cant particulary identify the word in close
parenthesis only..

=IF(ISERR(FIND(" ",C24))," ",LEFT(C24,LEN(C24)-FIND(" ",C24,1)))

Thanks in advance for the help!!

How can i extract some text data.....
 

I never thought how easy is that for you...I am trouble shooting that
formula since this morning..you save my day! thanks a lot Gary!!