Hej,


har lite bråttom med det här problemet så jag kopierar allt på engelska från en annan tråd.


Tusen tack för all hjälp.


Hello!


I would really apprecite help as I am working on something urguent.


I have data (about 1,000 cells) in Column B that needs to be split up between column B, C & D.


In Column B I have Adresses + Area codes + Countryname. I need it split up so that Adress stays in Column B and Area codes moves to C and country moves to D.


However, the country is the same for every single line so that might aswell be removed and I can add it easily to Column D.


Here are some examples:


Ahornsvinget 17 Nr. Felding 7500 Holsterbro Danmark
Hedevej 39 Bøgballe 7171 Uldum Danmark
Ålborgvej 707 9320 Hjallerup Danmark


And this is how I need it split up:


Ahornsvinget 17 Nr. Felding 7500 Holsterbro Danmark
Hedevej 39 Bøgballe 7171 Uldum Danmark
Ålborgvej 707 9320 Hjallerup Danmark


The areacode is always 4 digits and the country is always the same.


Thank you very, very much for any help!