one cell to many

[WRC]

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

 

[Mike H]

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

 

[Gord Dibben]

One method assuming data is in column A

In B1 enter =MID($A1,COLUMN(A:A),COLUMN($A:$A))

Copy across as far as you want.........say 16 cells.

Select those cells and copy down as far as you need.


Gord Dibben MS Excel MVP