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.

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.

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.