Splitting cells
in [General]
|
Prev: Validation list in data entry form
Next: Autofill
From: fazz on 5 May 2010 04:51 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
From: Jacob Skaria on 5 May 2010 05:01 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
From: fazz on 5 May 2010 05:17 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
From: Roger Govier on 5 May 2010 05:35 Hi in C1 =RIGHT(A1,2) in B1 =IF(LEN(A1)>2,LEFT(A1,LEN(A1)-2),A1) -- Regards Roger Govier 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
From: Jacob Skaria on 5 May 2010 05:46
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 |