I have a list of model descriptions in a column such as:

Accord 2.0i VTEC SE Auto HFT,VSA,17''tec
Civic 5Dr 1.8 ES Manual 17" Epsilon A

I need code to extract the first word, in this case a car model name, and
place it in the next column on its own. There is always a space after the
required word if this helps.

Also I need to extract the numbers describing the engine size ( 2.0 , 1.8
etc) and place them in column C. These could be in any position in the text
string in column A

I.e.

Column A Column B
Column C
Accord 2.0i VTEC SE Auto HFT,VSA,17''tec Accord 2.0
Civic 5Dr 1.8 ES Manual 17" Epsilon A Civic
1.8


Can you help please