Splitting cells

[fazz]

in cell A1 i have the numbers 123456789. i want cell B1 to have numbers
1234567 and cell C1 to have just 89. what is the formula? i have tried text
to columns

 

[Jacob Skaria]

If this is for extracting the first 7 characters use LEFT()

=LEFT(A1,7)
=RIGHT(A1,2)

 

[fazz]

Hello Jacob - i did not explain this very well.The digits in cell A1 is
variable length. In cell C1 i need the last 2 digits of cell A1. In cell B1 i
need the remainder of cell A1. this maybe more or less than 7 digits

 

[Roger Govier]

Hi

in C1
=RIGHT(A1,2)
in B1
=IF(LEN(A1)>2,LEFT(A1,LEN(A1)-2),A1)

 

[Jacob Skaria]

Change the 1st formula to

=LEFT(A1,LEN(A1)-2)

 

[fazz]

many thanks...thats done the job!

Change the 1st formula to

=LEFT(A1,LEN(A1)-2)