substitute

[tao94539]

Hi

I know how to use simple substitute
for example,

=substitute(A1, 2019,2020) will do replace 2019 with 2020,

How about if I want to do dynamically, like to replace with "YEAR" with "YEAR+1"

like replace 2014 with 2015, 2013 with 2014...

Thanks,
James

[Kaper]

If there is only year in A1 then

Please Login or Register  to view this content.

will do
If the year is at the end of text, like in
finished 2019
then use
=SUBSTITUTE(A1,RIGHT(A1,4),RIGHT(A1,4)+1)
and so on.

[tao94539]

Thanks,I understand what you are saying
so for following, it would eb difficult

Olim Bauda Barbera D'Asti Superiore Nizza DOCG Barbera 2015 1/3L

[avk]

Please Login or Register  to view this content.

Why not in simple way

[gue2013]

if the year is in cell "I4" and your string is in A1

Please Login or Register  to view this content.

cheers

[tao94539]

=SUBSTITUTE(A1;MID(A1;FIND($I$4;A1);4);MID(A1;FIND($I$4;A1);4)+1)

above seems not solve my issue

for example, I have string " I have 2017 wine", I want to change to "" I have 2018 wine" ( replace "2017" with "2017+1")

It may not be doable, I guess

[gue2013]

what exactly happens? (may be I forgot to tell that you have to change ";" to "," (german layout --> english)

look into the attachment

[AliGW]

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)