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