| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I seperate a 10 digit number into one cell for each number?
I want to take a 10 digit number (such as 1234567890) and be able to have
excel put each number into a specific cell automatically for OCR when faxing. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I seperate a 10 digit number into one cell for each number?
Hi
With the number in cell A1 enter in A2 =MID($A1,COLUMN(A1),1) copy across through B2:J2 -- Regards Roger Govier "Tkriger" wrote in message ... I want to take a 10 digit number (such as 1234567890) and be able to have excel put each number into a specific cell automatically for OCR when faxing. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I seperate a 10 digit number into one cell for each number?
SOlved it myself...Used MID
"Tkriger" wrote: I want to take a 10 digit number (such as 1234567890) and be able to have excel put each number into a specific cell automatically for OCR when faxing. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert a month to a quarter ...... | New Users to Excel | |||
| each number in cell should be 10 digit | Excel Worksheet Functions | |||
| New numbers | Excel Worksheet Functions | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| spread the number 123.45 so each digit goes to a different cell | Excel Worksheet Functions | |||
Linear Mode
