Joined
·
3 Posts
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 3 rows as example:
Column B: Ahornsvinget 17 Nr. Felding 7500 Holsterbro Danmark
Column B: Hedevej 39 Bøgballe 7171 Uldum Danmark
Column B: Ålborgvej 707 9320 Hjallerup Danmark
And this is how I need them split up:
Column B: Ahornsvinget 17 Nr. Felding Column C: 7500 Holsterbro Column D: Danmark
Column B: Hedevej 39 Bøgballe Column C: 7171 Uldum Column D: Danmark
Column B: Ålborgvej 707 Column C: 9320 Hjallerup Column D: Danmark
The areacode is always 4 digits and the country is always the same.
Thank you very, very much for any help!
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 3 rows as example:
Column B: Ahornsvinget 17 Nr. Felding 7500 Holsterbro Danmark
Column B: Hedevej 39 Bøgballe 7171 Uldum Danmark
Column B: Ålborgvej 707 9320 Hjallerup Danmark
And this is how I need them split up:
Column B: Ahornsvinget 17 Nr. Felding Column C: 7500 Holsterbro Column D: Danmark
Column B: Hedevej 39 Bøgballe Column C: 7171 Uldum Column D: Danmark
Column B: Ålborgvej 707 Column C: 9320 Hjallerup Column D: Danmark
The areacode is always 4 digits and the country is always the same.
Thank you very, very much for any help!