ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Address list (https://www.excelbanter.com/excel-discussion-misc-queries/168974-address-list.html)

Phil James

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




All times are GMT +1. The time now is 02:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com