Parse Alphanumeric vs. Text Into Two Columns

[Reade39]

Hi all - I have address data that includes both the city name and zip code. The zip code contains five to seven alphanumeric characters. The city names may contain multiple words. I would like to parse the column into two columns for city and zip code. Thanks in advance!

The data looks like this:

ADDRESS

LONDON EC1Y 2AB

EAST MORTON

NW7 4SD LONDON

HAMPSHIRE

ROMFORD RM3 8FU

SEVEN OAKS TN13 1JG

TN13 1JG

I would like the output to look like this:

ADDRESS	CITY	ZIP
LONDON EC1Y 2AB	LONDON	EC1Y 2AB
EAST MORTON	EAST MORTON
NW7 4SD LONDON	LONDON	NW7 4SD
HAMPSHIRE	HAMPSHIRE
ROMFORD RM3 8FU	ROMFORD	RM3 8FU
SEVEN OAKS TN13 1JG	SEVEN OAKS	TN13 1JG
TN13 1JG		TN13 1JG

[Felipe_Ribeir0 · Accepted solution]

Hi @Reade39 

One way of doing thisi