extract a recent year from a text in excel

[ExcelNewbie2020]

Sirs, i have values inputed in a cell combination of number (year), word, letter and other character. If its possible to extract the number and determine the recent year from the extracted number..

	RESULT
2019 text 2022	2022
2011, text, 2018	2018
2019, (AC), 2020	2020

Many Thanks,

 

[bebo021999]

Is it are you looking for?

Book1
	A	B
1		RESULT
2	2019 text 2022	2022
3	2011, text, 2018	2018
4	2019, (AC), 2020	2020
Sheet2

Cell Formulas
Range	Formula
B2:B4	B2	=AGGREGATE(14,6,MID(A2,ROW(INDIRECT("1:" & LEN(A2)-3)),4)+0,1)

 

[ExcelNewbie2020]

Is it are you looking for?

Book1
	A	B
1		RESULT
2	2019 text 2022	2022
3	2011, text, 2018	2018
4	2019, (AC), 2020	2020
Sheet2

Cell Formulas
Range	Formula
B2:B4	B2	=AGGREGATE(14,6,MID(A2,ROW(INDIRECT("1:" & LEN(A2)-3)),4)+0,1)

yes.. thank you very much..

 

[Tom.Jones]

In your pictures, recent year are in right position, then

=--Right (A2,4)

 

[Fluff]

Another option if you have the TextSplit function

=MAX(IFERROR(TEXTSPLIT(A2,{" ",","})+0,0))