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.

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