I want to add the following type of list in microsoft excel 2013:



1
Mary
5th Lane
2
Joe
Win Road

I want the number & address to be in one cell of its own 7 I can achieve this individually. However, I have a list of 1000 to put in, how do I achieve this by way of pasting all of it in but for each address to be in a cell of its own & for it to stay in the above format.

So for example the following must be in a cell of it's own the way you see it:

3
Richard Coe
Farm Street

The reason I want to do this is because I want to randomize the long list and for instance number 1 would appear anywhere from 1 to 1000 and could appear in the center.

I would very much appreciate anyone that could help me.