How to split data into two columns
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?
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago