Split 2,500 Excel Addresses

I have a spreadsheet containing roughly 2,500 rows where the entire mailing address currently sits in a single cell. Your task is to take that column and cleanly break each record into the following dedicated fields:

• Address 1
• Address 2
• Address 3
• City
• County
• Country
• Postcode

Because the source data uses mixed delimiters—commas, line breaks, an occasional extra space—formula-only solutions rarely catch everything. I’m therefore fine if you use a mix of Excel functions, Power Query, VBA, or even an external script (Python/pandas, etc.) as long as the end result lands back in Excel and each component sits in its own column with consistent casing and no trailing punctuation.

Before final delivery please spot-check for obvious anomalies (e.g., missing postcodes or shifted columns) so I receive a ready-to-use, fully organised file. I’ll share the workbook immediately on award; you simply return a cleaned .xlsx. If anything in the raw data looks ambiguous, flag it in a separate sheet so I can review.