breaking apart a SKU's data fields.

[navanax1]

I have the following type of SKU's in text form (below) that i need to seperate the alpha sufix from. I need both the base number and the sufix in seperate fields.

I am using =left(a1,4) and =right(a1,1) to get 1000 A etc and have been adjusting for each item since they are all mixed up but after going through about 500 of 78,000 lines I just thought I would ask is their a better way.

I think I want to have a formula like =right( remove letters until a numeric occurs and keep the rest) and one formula that =right(keep all alpha to the right of the numeric). but I have failed in finding one.

Can someone help, thanks a million.

navanax1

1000A
1000AA
1000AAA
10000A
10000AA
10000AAA
100000A
1000000AA
1000000AAA
10000000A
10000000AA
10000000AAA
1A000A
1A000AA
1A000AAA
1A0000A
1A0000AA
1A0000AAA
1A00000A
1A000000AA
1A000000AAA
1A0000000A
1A0000000AA
1A0000000AAA
1A000A
1A000AA
1A000AAA
1000A0A
1000A0AA
1000A0AAA
1000A00A
10000A00AA
10000A00AAA
100000A00A
100000A00AA
100000A00AAA

[Pepe Le Mokko]

Hi

what s a SKU?