Thread: How do I seperate a 10 digit number into one cell for each number?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
  
Posts: 2,886
Default 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.


Reply With QuoteReply With Quote