I want to export all my customers to a csv file but I only get the first line of the billing address. Is it possible to export the whole address?
Hi Peter,
The CSV file includes the full customer address including multiple lines.
However, Microsoft Word only shows the first line by default. To show more
than the first line, increase the height of the row by dragging the row
separator down.
Alternatively you can import the CSV file into Google Sheets which shows
the full address by default.
Mark,
Thanks for getting back to me.
I needed the address on one line in order to import it into another program. I achieved it as follows:
Press Ctrl+H to activate the Replace dialog.
Click in the 'Find what' box and press Ctrl+J. This inserts an (invisible) line break.
Click in the 'Replace with' box and enter a comma or semicolon (, or ;).
Click Replace or Replace All.
Regards
Peter
Hi Peter,
OK glad to hear you have resolved the issue by using the Replace All
feature.