separate numbers out of string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=MID(B1,2,9)

=MID(B1,11,2)

=MID(B1,19,3)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top