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
”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
With your subscription - you'll gain access to our exclusive IT community of thousands of IT pros. You'll also be able to connect with highly specified Experts to get personalized solutions to your troubleshooting & research questions. It’s like crowd-sourced consulting.
We can't always guarantee that the perfect solution to your specific problem will be waiting for you. If you ask your own question - our Certified Experts will team up with you to help you get the answers you need.
Our certified Experts are CTOs, CISOs, and Technical Architects who answer questions, write articles, and produce videos on Experts Exchange. 99% of them have full time tech jobs - they volunteer their time to help other people in the technology industry learn and succeed.
We can't guarantee quick solutions - Experts Exchange isn't a help desk. We're a community of IT professionals committed to sharing knowledge. Our experts volunteer their time to help other people in the technology industry learn and succeed.