How do you parse Germany zip codes from an address?

[nberumen]

Hello All 🖐,

I am trying to use regex or any formula to parse the Germany Zip Codes from the Cities in the first column. I want to make sure they each have their own column, see desired outcome below. What is the best approach for this?

Starting Data:

Billing City / District	Billing Country
D-12345 Karlsruhe	Germany
23456 Baes	Germany
D-98745 Lau	Germany

Desired Outcome:

Billing City / District	Billing Zip Code	Billing Country
Karlsruhe	D-12345	Germany
Baes	23456	Germany
Lau	D-98745	Germany

[binu_acs · Accepted solution]

@nberumen One way of doing this

[nberumen]

Thank you @binu_acs !

That fixed it, I appreciate the help and the quick response!

[AdwaitTarudkar]

Can you also use text to column with delimiter as " " and then rename columns?

[nberumen]

Hello @AdwaitTarudkar ,

I did try using " " as a delimiter in the text to columns tool but some of the cities that I have also have two words and it would split them up in the wrong place. For example 12345 New York  would split in between New and York.

[AdwaitTarudkar]

Hi @nberumen, That makes sense. Thanks!