Pull Data from Text Field in Excel
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.
YEAR-EXTRACTION.xlsm
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.
YEAR-EXTRACTION.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Brian - I was traveling and did not get to close out the accepted answer. Sorry for the delay -
No problem. Thanks, mmmcdee.
ASKER