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

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

--
Jacob (MVP - Excel)


"fazz" wrote:

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