hi,

With your strings in column A starting in A1 put this in B1 and drag right
16 columns. Select these 16 new cells and drag down as far as required.

=MID($A1,COLUMN(A1),1)

Mike

"WRC" wrote:

In one column I have list of item numbers. Length of each cell varies i.e.
no. of characters (Ex: 16 characters or 15 or 14 characters per cell).
I want to move each of the characters which is in one cell to different cells.

Thanks