Hi all,
I need help - I have addresses and I need to extract 5 digit number and string that comes after those digits.
For ie.:
Sarajevska 27, 10000 Zagreb - I need 10000 Zagreb
Stari hrast 45, 10431 Sveta nedelja, rakitje - I need 10431 Sveta nedelja, rakitje
Gustava Krkleca 16/1, Srdoči, 51000 Rijeka - I need 51000 Rijeka
Kolombera 75/A, 52470 Umag (Umago) - I need 52470 Umag (Umago)
GORNJE LADANJE,VATROSLAVA LISINSKOG 4, 42207 VINICA - I need 42207 VINICA
I have no idea how to do this with VBA, if someone is willing to help, i would be more than grateful.
Thnx,
Kind regards,
Matija
I need help - I have addresses and I need to extract 5 digit number and string that comes after those digits.
For ie.:
Sarajevska 27, 10000 Zagreb - I need 10000 Zagreb
Stari hrast 45, 10431 Sveta nedelja, rakitje - I need 10431 Sveta nedelja, rakitje
Gustava Krkleca 16/1, Srdoči, 51000 Rijeka - I need 51000 Rijeka
Kolombera 75/A, 52470 Umag (Umago) - I need 52470 Umag (Umago)
GORNJE LADANJE,VATROSLAVA LISINSKOG 4, 42207 VINICA - I need 42207 VINICA
I have no idea how to do this with VBA, if someone is willing to help, i would be more than grateful.
Thnx,
Kind regards,
Matija