separate numbers out of string

[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

 

[Trevor Shuttleworth]

Use the MID function

Regards

Trevor

 

[Bob Phillips]

=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)

 

[Guest]

Got it thanks!