View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
 
Posts: 1,089
Default separate numbers out of string

Use the MID function

Regards

Trevor


"joesf16" wrote in message
...
Hi.


I have a 21 digit number, and I want the 2'nd through 10'th digits placed
in
cell B1. I would like the 11'th and 12'th digits placed in cell C1. I
would
like the 19'th through 21'st digits placed in cell C3. How do I do this?


Here is an example of what I am trying to do:

A B
C D
1 213042156298658923911 130421562 98
911
2
3
4
5
--
vze2mss6