| Home |
| Search |
| Today's Posts |
|
#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 |
| 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) | |||
Threaded Mode
