Separating a multi-line address field into separate reporting columns

Occasionally Workbooks users want to export people data in order to merge it into a hard copy mailshot.  In these circumstances there is a requirement to show the different lines of a multi-line address field in separate columns in a report so that it can be exported easily to Excel.  This is possible to do by using a substring formula in your Workbooks report.  The same technique can be used to split the contents of other multi-line text fields into different columns but for this example the focus is on the street address.