troubleshooting Question

Pull Data from Text Field in Excel

Avatar of mmmcdee
mmmcdeeFlag for United States of America asked on
Microsoft Excel
4 Comments1 Solution452 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
redmondb

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros