I would start out with using the Text to Columns feature to separate the
words in each cell into single items going across a row.

I would then take each row and copy it and paste/special with transpose
checked to another worksheet. This would take each row of numbers and
convert it to a column.
--
Gary''s Student


"dick" wrote:

I have columns of cells that have information I need to separate into
separate cells
Information in each cell will vary but they have one thing in common. The
information is either a word with a number or just a number
Example
LASERJET 2000D LASERJET 2100
LASERJET 1100 1100A 1100AXI 1100SE 1100XI 3200
LASERJET 1010 LASERJET 1012 LASERJET 1015 LASERJET 3015 LASERJET
MFC 8300 8500 8600 8700 9600 9700 9750 9800

Each line above is a cell. I am trying to separate these items such that
each resulting cell has a word and a number or just a number
the second line (cell) would look like
Laserjet 1100
1100A
1100AXI
1100SE
1100XI
3200
Any ideas?
Thanks in advance