This might be a quicker work around for you. Highlight and copy all the info
on your sheet. Open a blank "Notepad" and paste everything in there.

While it's in raw form in Notepad, put the cursor at the end of each entry
and hit the Enter/Return key. Do that until each of your entries is on it's
own line on the Notepad document like so:

1234
3425
34234

Now copy your numbers from Notepad and past into your Excel sheet, and your
entries should each be in their own row.




"Booj" wrote:

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?