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

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

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

On Tue, 13 Jan 2009 09:11:02 -0800, 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