separating last two digits

[ChrisS]

If I have a column with numbers such as 1234567 (7 digits)
can I split that and make two new columns?

so column A row 1 may be 1234567
column B row 1 12345
column C row 1 67

thanks

 

[duane]

col b =left(a1,5)
colc = right(a1,2

 

[Myrna Larson]

If the numbers are always 7 digits and you always want to split 5 and 2, you
can also use Data/Text to Columns. Specify Fixed Width, and put the split
marker between the 5th and 6th digits.

 

[Ron Rosenfeld]

If I have a column with numbers such as 1234567 (7 digits)
can I split that and make two new columns?

so column A row 1 may be 1234567
column B row 1 12345
column C row 1 67

thanks

A1: 1234567
B1: =INT(A1/100) --> 12345
C1: =MOD(A1,100) --> 67


--ron

 

[Dana DeLouis]

Maybe another option if they are integers.

[B1] =INT(A1/100)
&
[C1] =MOD(A1,100)