Link to home
Start Free TrialLog in
Avatar of mmmcdee
mmmcdeeFlag for United States of America

asked on

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.
Avatar of redmondb
Flag of Afghanistan image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mmmcdee


Thanks Brian - I am testing now
Avatar of mmmcdee


Thanks Brian - I was traveling and did not get to close out the accepted answer.  Sorry for the delay -
No problem. Thanks, mmmcdee.