read as you scroll

[kuzna26]

Hi Guys,

please I would like your help,

I have this reference in one cell and I want to scroll it down with this sequence

MRM/R01/2018
MRM/R02/2018
MRM/R03/2018
MRM/R04/2018

But the sequence is NOT to reading , instead it reads the 2018, 2019 e 2020

Thank you ,

[FDibbins]

Try this, copied down...
=LEFT(G5,5)&TEXT(--MID(G5,6,2)+1,"00")&RIGHT(G5,5)

[sonukiller]

First type MRM/R01, and scroll.
After that type /2018.
and use ' CONCATENATE'.
Then scroll and you will get as you wanted.
Book.png