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 |
