Splitting Text
 

I have a worksheet with data split by a "/" eg. BARRISTER/F. GREY
I want to split the data into two adjacent columns
eg "BARRISTER", "F. GREY"

I have tried =LEFT(A1,FIND("/",A1)-1) for the first field, which works,
and =MID(A1,FIND("/",A1,99)for the second, which doesn't, of course (I
understand why).

What should I do,instead, please?

Jim Berglund

Splitting Text
 

close
=MID(A1,FIND("/",A1,1)+1,99)

--


Gary Keramidas
Excel 2003


"jazzzbo" wrote in message
...
I have a worksheet with data split by a "/" eg. BARRISTER/F. GREY
I want to split the data into two adjacent columns
eg "BARRISTER", "F. GREY"

I have tried =LEFT(A1,FIND("/",A1)-1) for the first field, which works,
and =MID(A1,FIND("/",A1,99)for the second, which doesn't, of course (I
understand why).

What should I do,instead, please?

Jim Berglund

Splitting Text
 

Data/ text to columns
Delimited /
--
David Biddulph

jazzzbo wrote:
I have a worksheet with data split by a "/" eg. BARRISTER/F. GREY
I want to split the data into two adjacent columns
eg "BARRISTER", "F. GREY"

I have tried =LEFT(A1,FIND("/",A1)-1) for the first field, which
works, and =MID(A1,FIND("/",A1,99)for the second, which doesn't, of
course (I understand why).

What should I do,instead, please?

Jim Berglund