Morning,

I am sure there is an easy formula to do this, but basically I have Column A that contains a huge list of various Makes and Models of Cars in this format:
Ford Focus 1.6 Ghia LX

I need to split this so that just the Make goes into Column B and then whatever is left of the data goes into Column C as the 'model'.

Text to columns cannot do this as the make of vehicle varies in length and also as there are several spaces in the data meaning it splits often into 5 or 6 columns. Now I could then just concatenate the two columns, but given that the spreadsheet is ovre 10,000 rows in size, it seems a bit long winded doing it this wway.

Any ideas?