Prev: Validation list in data entry form
Next: Autofill
From: fazz on 5 May 2010 08:24
many thanks...thats done the job!

"Jacob Skaria" wrote:

> 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
First  |  Prev  | 
Pages: 1 2
Prev: Validation list in data entry form
Next: Autofill