I am trying to pull YEAR data from a text within a Cell that contains two ways of displaying YEAR - Example: 2010 or 1997 or 97 or 1999 or 99. I have attached my Excel doc using lots of TRIM/IF/FIND parameters. I was able to segregate the fields to their proper YEAR column. This is not very efficient and of course not easy.
All I really need is a way to PULL the YEAR data from a specific column containing subject text. When YEAR data is found like 2000 or 2011 or 97 or 98, Excel copies that year to a column and corrects the two digit year and makes it a four digit year. The data (text) I am pulling from will contain data from 1997 to 2014 - years are subject to change as time goes by of course.