Address list

When I export my address list to a text file, it comes out like this:

name
E-mail address:
address

How can I make it come out like this:

name address

This is exactly how it appears in the "addresses" box. I want to copy that
exactly, then put it into an Excel spreadsheet -- or put it directly into a
spreadsheet.

I think I found a way last year, but can't remember it. I've tried using a
macro, but that didn't work.

Thanks...

Phil