separate numbers out of string
 

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

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

separate numbers out of string
 

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

"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

separate numbers out of string
 

Got it thanks!
--
vze2mss6


"joesf16" wrote:

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