From vertical address labels to horizontal list

[Skarlett_One]

I'm using Excel 2003, and I'm trying to go from address labels to a single line per household. I have nearly 10,000 lines to go through. Is there any way of doing it faster than copy/paste/delete ad nauseum. The original one looks like this

|Jane Doe
|123 Any Street

and I need it to be:

Jane Doe |123 Any Street| Postal Code| City

I don't know how to word it to search for this request. I've been searching for 2 days, and I can't find what I'm looking for.

Help?

 

[Skarlett_One]

Ha! Thanks though. Should I do another thread with that as the question? I see a bunch for how to do it after separating the number out, but that doesn't help, especially when I need to keep the owners attached to the address. :/

 

[Fluff]

Yes, a new thread would probably be best.