Avatar of mmmcdee
mmmcdee
Flag 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.
YEAR-EXTRACTION.xlsm
Microsoft Excel

Avatar of undefined
Last Comment
redmondb

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
redmondb

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
mmmcdee

ASKER
Thanks Brian - I am testing now
mmmcdee

ASKER
Thanks Brian - I was traveling and did not get to close out the accepted answer.  Sorry for the delay -
redmondb

No problem. Thanks, mmmcdee.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23