How to sort [data] to different column

[excelhero]

I want to separate [number] part to next column, A column Stockholm [10] Boden [32330] Borlänge [1204] Borås [332] This is how i want it A column B column Stockholm [10] Boden [32330] Borlänge [1204] Borås [332] <tbody> </tbody> help, much appreciated! Thank you <tbody> </tbody>

<tbody>
</tbody>

 

[FormR]

Hi, try:

Excel Workbook
	A	B
1	A column	B column
2	Stockholm [10]	[10]
3	Boden [32330]	[32330]
4	Borlnge [1204]	[1204]
5	Bors [332]	[332]
Sheet1

 

[excelhero]

wow !!
Nice it worked.

Thank you so much! <3

 

[excelhero]

Oh, one more thing
How i can clean the numbers from A1 column [numbers] ?
Then i'm good

Thank you

 

[FormR]

How i can clean the numbers from A1 column [numbers] ?

Like this maybe:

Excel Workbook
	A	B	C
1	A column	B column	C column
2	Stockholm [10]	Stockholm	[10]
3	Boden [32330]	Boden	[32330]
4	Borlnge [1204]	Borlnge	[1204]
5	Bors [332]	Bors	[332]
Sheet1

 

[excelhero]

Amazing, that worked
Thank you!