Separate the address column in excel from an export

Modified on Wed, 20 Feb 2019 at 09:14 AM

Exporting a Print List and Separate the Address Column in Excel

Step-by-Step Process

  • Build your Search list criteria
  • Select your required Print List
  • Export this list to Excel using the icon in the top left corner
  • Save as a Microsoft Excel (*.xls) file

  • Open the Excel file
  • Highlight the spreadsheet (Click in the top left cell box between A and 1)
  • Un-merge the cells (Select Merge & Centre)

  • Highlight the address column you wish to separate
  • Select the Data tab
  • Select Text to Columns

  • Select Delimited
  • Select Next

  • Select Comma
  • Select Next

  • Select General
  • Select Finish

  • Select OK

You’re address fields will now be separated, we suggest you review the data (addresses may have extra columns and you may need to tidy some fields) before using.

Where a space is in the column text in place of a comma;

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article