parsing apart codes with differing lengths

[C.S.]

I have a list of numbers

0010001
0090001
10001
0110001
020001

I need to split these apart with the last four digits being in one column and the rest in another.

example:

column B column C
001 0001
009 0001
1 0001
011 0001

The column C portion i can get with a simple right function but I can't figure out how to make the left side account for the differing lengths.

 

[Ron Coderre]

Try this...
B1: =LEFT(A1,LEN(A1)-4)
C1: =RIGHT(A1,4)

Is that something you can work with?

 

[C.S.]

works like a charm, thanks bro!