Change the 1st formula to

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

--
Jacob (MVP - Excel)


"fazz" wrote:

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

"Jacob Skaria" wrote:

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