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.

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][TABLE="width: 302"]
<tbody>[TR]
[TD="width: 302"]Audi Q7 2013[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]2013[/TD]
[/TR]
[TR]
[TD][TABLE="width: 302"]
<tbody>[TR]
[TD="width: 302"]Audi R8 Spyder 2016[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 302"]
<tbody>[TR]
[TD="width: 302"]Audi S7 2016[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 302"]
<tbody>[TR]
[TD="width: 302"]BAIC A1 Hatchback 2016[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 302"]
<tbody>[TR]
[TD="width: 302"]Bentley Continental Flying Spur 2013[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 302"]
<tbody>[TR]
[TD="width: 302"]Mercedes-Benz GL-Class 2015[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 302"]
<tbody>[TR]
[TD="width: 302"]Cadillac XLR 2007[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 302"]
<tbody>[TR]
[TD="width: 302"]Lamborghini Aventador Roadster 2013[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 302"]
<tbody>[TR]
[TD="width: 302"]King Long Mini Van 2016[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 302"]
<tbody>[TR]
[TD="width: 302"]Aston Martin V8 Vantage Roadster 2010[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]




















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)