Thanks.
Chip Pearson got it appreciate all the help. I now understand.

"Gary''s Student" wrote:

Say we are going to put a number in A1. In B1 enter:

=MID($A1,COLUMN()-1,1) and copy across
--
Gary''s Student - gsnu200818