Finding the only the next 4 characters of group of string in a cell

[EinarOSies]

I have a list of cells containing these values

acd=2021, sad=2020, aaa=2018

sad=2016,fad=2005

right=2003, mum=2008,sad=2027

fad=2001, aaa=2019, daf=2028, sad=2002

fad=2007, mum=2004, acd=2014, sad=2013

Please I want a formula to extract just the 4 numbers after the string "sad=". I want to use it to drag to all the cells to return just 4 numbers



Einar.

 

[StephenCrump]

Try: MID(A1,SEARCH("sad=",A1)+4,4)

Or to convert to numeric: --MID(A1,SEARCH("sad=",A1)+4,4)