Arise Software Ltd

This report can be used to export addresses to MS Excel.

For all other reports that require each address line to be split.

First, the address needs to be in a single line. In this example, column D contains the address and column E has the formula that converts the multi line address to a single line =SUBSTITUTE(SUBSTITUTE(D2,CHAR(10),";"),CHAR(13),"")


The next step is to copy and paste column E to column F, as a value

The final step is to then use Excel to separate the individual address lines into their own columns.
https://support.office.com/en-us/article/Split-text-into-different-cells-30b14928-5550-41f5-97ca-7a3e9c363ed7