perl or Simple Excel macro
Posted on 2014-01-28
I have data like below.
Detmolder Str. 515 33605 Bielefeld
Should be like this when seperated:
Detmolder Str. 515 , 33605 Bielefeld
So the format schould be:
ADDRESS ,ZIP CITY
So that it takes the address line in 1 column, and the zip + city in 1 column.
That way, if the address line looks like this now, where it has no zip-code, then it will just be the city in the second column.
ADDRESS , CITY