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

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

"Ken Johnson" wrote in message
oups.com...
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 :-))

Hi Ken Johnson & Bob Phillips,


Thanks for the reply It worked for me also.

Regards

Ramana

If the text in your column has a common point where you want to split,
or it has some type of delimination you can select a single column, go
to the menu bar - select "Data" - then select "Text to Columns" and
follow the information on the pop-up menu.
If you do this and you want to split a column into 2 or more columns -
make sure the same number of columns to the right are "blank" or you
will overwrite what is already there. The program will give you a
warning and ask "do you want to do this.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.hightechtalks.com/m390
View this thread: http://www.hightechtalks.com/t2296610