Separate text from numbers in a string?

[LoriD]

Is there a way to separate text from numbers, (other than text to columns)
My data is all different lengths, nothing consistent,plus I want to put the separated data in another column.
I'm hoping there is a formula???
Thanks in advance for your help.

 

[CHINH CK]

Welcome to the MrExcel board!

Try these formulas, copied down.

Excel Workbook
	A	B	C
1
2	Hop KC lon mut dua sua 200grx12Hop	Hop KC lon mut dua sua	200
3	Hop KC lon-mut gung deo 200grx12Hop	Hop KC lon-mut gung deo	200
4	Hop mut tet thap cam vuong 550g x 6 hop	Hop mut tet thap cam vuong	550
5	Hop mut tet thap cam chu nhat 510gx6hop	Hop mut tet thap cam chu nhat	510
6	Hop mut tet bi mass (450g) x 10 hop	Hop mut tet bi mass (	450
7	Hop KC lon-mut mang cau 250grx12Hop	Hop KC lon-mut mang cau	250
8	Hop KC lon-mut khoai lang 300grx12Hop	Hop KC lon-mut khoai lang	300
9	Mut TC hop chiec la 350grx10Hop	Mut TC hop chiec la	350
10	Mut TC HN Oval loc xuan 380grx6Hop	Mut TC HN Oval loc xuan	380
11	Mut TC HN vuong loc xuan 465gx6Hop	Mut TC HN vuong loc xuan	465
12	Hop mut tet gung mass (400g) x 10 hop	Hop mut tet gung mass (	400
13
Split Text

Wow, im really dont expect this quick. thank you very much Peter!!!!!

 

[4dnan]

Hi, can someone help me with this case:


01100 Objekti od betona i metala ,kame 1,847,854.43 0.00 0.00 0.00 1,847,854.43 0.00 1,847,854.43 0.00

01200 putnicki automobili 68,607.20 58,647.20 0.00 0.00 68,607.20 58,647.20 9,960.00 0.00

01230 telefonska centrala 11,685.62 0.00 0.00 0.00 11,685.62 0.00 11,685.62 0.00

Is there a formula to separate these contents to get number/text/number?

Tnx