How to Breakup text in to two parts ina cell

[ramana]

Hi Everybody,

I want to Split text ina cell in to two parts in to the
other cells. Here I'm giving an example of my problem.

In cell A1 = B1OL(03) nOW WHAT i NEED IS

In cell B1 = B1OL
In Cell C1 = 02 Shoud be displayed , I.e. in B1 it should disply the
characters which are before the bracket(open parantesis) and in C1 it
should display the characters which are with in the brackets. If any
body have suggestions tell me.

Thanks and Regards

Ramana

 

[Ken Johnson]

Hi Ramana,
Will this do?

In B1:
=LEFT(A1,FIND("(",A1,1)-1)

In C1
=MID(A1,FIND("(",A1,1)+1,FIND(")",A1,1)-FIND("(",A1,1)-1)

It worked for me.
Ken Johnson

 

[Bob Phillips]

Hi Ramana,
Will this do?

In B1:
=LEFT(A1,FIND("(",A1,1)-1)

In C1
=MID(A1,FIND("(",A1,1)+1,FIND(")",A1,1)-FIND("(",A1,1)-1)

alternative

=SUBSTITUTE(MID(A1,FIND("(",A1,1)+1,99),")","")

one less function call )

 

[ramana]

Hi Ken Johnson & Bob Phillips,


Thanks for the reply It worked for me also.

Regards

Ramana