| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Splitting cells
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Splitting cells
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Splitting cells
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Splitting cells
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Splitting cells
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Splitting cells
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Splitting cells | Excel Worksheet Functions | |||
| Splitting Cells | Excel Worksheet Functions | |||
| Splitting cells? | Excel Discussion (Misc queries) | |||
| splitting cells | Excel Worksheet Functions | |||
| Splitting Cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
