how can I separate the different length data in a cell

[zubair99]

how can I separate the different length data in a cell. All rows has not same length of data I show a sample. I need
separate YEARS to the next column for all rows. I have 30 thousand rows like these.

I need automatic solution for this.

Audi Q7 2013 <tbody> </tbody>	2013
Audi R8 Spyder 2016 <tbody> </tbody>
Audi S7 2016 <tbody> </tbody>
BAIC A1 Hatchback 2016 <tbody> </tbody>
Bentley Continental Flying Spur 2013 <tbody> </tbody>
Mercedes-Benz GL-Class 2015 <tbody> </tbody>
Cadillac XLR 2007 <tbody> </tbody>
Lamborghini Aventador Roadster 2013 <tbody> </tbody>
King Long Mini Van 2016 <tbody> </tbody>
Aston Martin V8 Vantage Roadster 2010 <tbody> </tbody>

<tbody>
</tbody>

Thanks in Advance
-zubair

 

[sheetspread]

Excel 2010
	A	B
1	Audi Q7 2013	2013
2	Audi R8 Spyder 2016	2016
3	Audi S7 2016	2016
4	BAIC A1 Hatchback 2016	2016
5	Bentley Continental Flying Spur 2013	2013
6	Mercedes-Benz GL-Class 2015	2015
7	Cadillac XLR 2007	2007
8	Lamborghini Aventador Roadster 2013	2013
9	King Long Mini Van 2016	2016
10	Aston Martin V8 Vantage Roadster 2010	2010
Sheet16

Cell Formulas
Range	Formula
B1	=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",100)),100))

or just =right(a1,4) if the rest of your data is in the same format

 

[zubair99]

Thank You I will be checking it.

 

[T. Valko]

Maybe this...

=--RIGHT(A1,4)