Splitting Multiple Text and Numbers in excel

Hi

I was wondering if anyone could help me split the text in the attached excel file.

It has multiple numbers and text that need splitting up.

Ideally Id like to use a formula rather than functions or VBA.

Originally Posted by AlKey

Enter formula in E2 and copy across and down

Formula:

=TRIM(MID(SUBSTITUTE(" "&REPLACE($C2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},$C2&1/17)),," ")," ",REPT(" ",99)),99*COLUMNS($C:C),99))

v	C	D	E	F	G	H
1	Data
2	Kemp8f std C4		Kemp	8f	std	C4
3	Nkt9f Gd/Fm C2		Nkt	9f	Gd/Fm	C2
4	Pont8f Gd/Fm C4		Pont	8f	Gd/Fm	C4
5	Bri7f Gd/Sft C4		Bri	7f	Gd/Sft	C4
6	Gwd9f Gd/Fm C3		Gwd	9f	Gd/Fm	C3
7	Rip9f Gd C4		Rip	9f	Gd	C4
8	Crl9f Gd/Sft C5		Crl	9f	Gd/Sft	C5
9	Crl9f Gd/Sft C5		Crl	9f	Gd/Sft	C5
10	Yar11f Gd/Fm C4		Yar	11f	Gd/Fm	C4
11	Don12f Gd/Fm C4		Don	12f	Gd/Fm	C4
12	Crl7f Gd/Fm C5		Crl	7f	Gd/Fm	C5
13	Bev9f Gd C4		Bev	9f	Gd	C4
14	Muss8f Gd/Fm C4		Muss	8f	Gd/Fm	C4
15	Kemp8f std C4		Kemp	8f	std	C4
16	Chfd10f std C4		Chfd	10f	std	C4
17	Wnds10f Gd/Sft C4		Wnds	10f	Gd/Sft	C4
18	Red10f Gd C4		Red	10f	Gd	C4
19	Rip12f Gd C4		Rip	12f	Gd	C4
20	York10f Gd C4		York	10f	Gd	C4
21	Sand10f Gd/Sft C4		Sand	10f	Gd/Sft	C4
22	Don7f Gd/Fm C5		Don	7f	Gd/Fm	C5
23	Hayd7f Gd/Sft C5		Hayd	7f	Gd/Sft	C5

Thank you so much I've added reputation.

Will the split always be determined as follows:

Split at first numeric value
Then
Split at first space
Then
Split at 2nd space

To always give 4 segments