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