I have an Excel file in which every record currently stores the entire address in a single cell. I need that column broken down into discrete fields—house number, street name, city, state or province, postal code and country—no matter where the address comes from. Some entries follow a UK style, others Irish, and a few combine several conventions in the same line, sometimes with commas, sometimes just spaces or other punctuation. Please build a repeatable solution that copes with those global variations and the mixed delimiters, then deliver a clean spreadsheet where each of those components sits in its own column. Whether you prefer advanced Excel formulas, Power Query, VBA or an external script in Python is up to you as long as I end up with: • the updated workbook containing the parsed columns for every row • your method embedded or clearly documented so I can re-run it if new records come in Accuracy is essential; fields must stay aligned even when a part of the address is missing (for example, addresses without a state or with an alphanumeric postal code). If something cannot be parsed confidently, leave the cell blank rather than guess and flag the row for review. We will need to be able to reuse this solution on other exports.