|If the only occurrences of 2014 is in your dates, then a simple Replace All (Home Ribbon... Find and Select) should work.|
If 2014 might exist in a piece of non-date data, you can improve your accuracy by including some part of the date format in the Find What field, e.g.
Just make sure you use the same format in the Replace With field, e.g.
If 2014 might exist as non-date data with those delimiters, e.g.
Date Data: 10/31/2014
Non-Date Data: Part 88767 fits 2013/2014/2015 vehicles
...then a VBA solution should work. Let me know if you want me to work on something like that. If so, please provide some sample dates and sample non-date data so I know what I am working with.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03