How to Breakup text in to two parts ina cell

R

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
 
K

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
 
B

Bob Phillips

Ken Johnson said:
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)
Click to expand...

alternative

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

one less function call :))
 
R

ramana

Hi Ken Johnson & Bob Phillips,


Thanks for the reply It worked for me also.

Regards

Ramana
 
W

wjohnson

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, g
to the menu bar - select "Data" - then select "Text to Columns" an
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 yo
will overwrite what is already there. The program will give you
warning and ask "do you want to do this
 
Top