How do I seperate a 10 digit number into one cell for each number?

T

Tkriger

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.
 
R

Roger Govier

Hi

With the number in cell A1 enter in A2
=MID($A1,COLUMN(A1),1)
copy across through B2:J2
 
Top