J
jazzzbo
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
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