Gary's Student:
Thanks for you response however, I am actually starting in B2 thru D2. Does
this change the formula at all?
kbkst

Gary''s Student wrote:
In B1 thru D1 put:

=LEFT(A1,1) =MID(A1,3,3) =RIGHT(A1,4)

This may not be able to be done, but it doesn't hurt to ask.

[quoted text clipped - 11 lines]
Thanks,
Shaety

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200602/1