[budward]

I have a list of 4 digit numbers and am looking for a formula to divide each number into 3 pairs.
Ex 1234.....12....23....34
Thanks in advance for any help!!
Bud

 

[bomb #21]

=LEFT(range,2) ; =MID(range,2,2) ; =RIGHT(range,2)

 

[budward]

Thanks bomb#21.
Someday I might know all this stuff.
Happy New Year!!!!!