If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Booj" wrote in message
...
I have a worksheet that has multiple numbers (1234, 3425, 34234,etc.) in a
single cell. I need to separate these and create a new row for each one
(ie.
A1 1234, A2 3425, A3 34234, etc.). Currently I'm having to insert
columns,
convert text to columns, transpose the data, then copy and paste the rest
of
the data from the other columns...Is there an easier way?