Solved how to change year 2014 to 2015 on existing excel spreadshee

October 31, 2014 at 21:41:43
Specs: Windows 7
on existing excel spreadsheet with dates of 2014 need to change these dates to next year, 2015. Want to preserve all other existing dates and data.

See More: how to change year 2014 to 2015 on existing excel spreadshee

Report •

November 1, 2014 at 02:05:53
✔ Best Answer
This might be what you need to know:

Report •

November 1, 2014 at 04:34:08
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.

, 2014

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

Report •

Related Solutions

Ask Question