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 34 weeks ago
6 years 20 weeks ago
6 years 32 weeks ago
6 years 35 weeks ago
6 years 36 weeks ago
6 years 42 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago