Split 1 col into 2 cols

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Betty Csehi - 27 Sep 2007 15:38 GMT

I have the following in col A:
RMMX003245
TFM127854

I want cols B and C to contain the split info from col A:

Col B Col C
RMMX 003245
TFM 127854

I can do the =right and =left formula, but the problem is that, while there
will always be 6 numbers, there will not always be the same number of
letters. However, there will always be at least 1 letter and no more than 4
letters. Can someone tell me how to do this?

Thanks!

Reply to this Message

JW - 27 Sep 2007 15:52 GMT

Col B
=LEFT(H2,LEN(H2)-6)

Col C
=RIGHT(H2,6)

> I have the following in col A:
> RMMX003245
[quoted text clipped - 12 lines]
>
> Thanks!

Reply to this Message

JW - 27 Sep 2007 15:53 GMT

Meant to change the references to column A.
Col B
=LEFT(A2,LEN(A2)-6)

Col C
=RIGHT(A2,6)

> Col B
> =LEFT(H2,LEN(H2)-6)
[quoted text clipped - 18 lines]
> >
> > Thanks!

Reply to this Message

Betty Csehi - 27 Sep 2007 21:38 GMT

Thanks for the help. I do appreciate it!

> Col B
> =LEFT(H2,LEN(H2)-6)
[quoted text clipped - 20 lines]
>>
>> Thanks!

Reply to this Message