Hello,
I have an Access database that stores addresses in text fields, and shows them on a form where the field can have multiple address lines. This is great when we are trying to copy/paste text for an envelope.
However, I would like export the table and take the 3 or 4 lines of the address and list them in 3-4 columns of an Excel file. The first line of the table would be the first column of the Excel file. The second, the second. You get the idea.
When I look at the exported Excel file (I have attached a sample) the address shows only the first line in each cell. You have to double-click the cell for all of the address to show.
What macro can be used to take the one address (with multiple lines) and make it into multiple columns instead?
Thank you so much!
Mike