Forum Discussion
Auto Fill Middle Sequence
Simply put this formula in somewhere lets say in A1 and drag down it will create your needed strings in sequence. please see the file which I attached. Please note that the last two digits are from dynamic year. meaning if you check this formula next year it will be 19 for 2019
if you want to change to static year then replace the below formula to ="RAH/"&(419+ROWS($A$1:A1)&"-18")
="RAH/"&(419+ROWS($A$1:A1)&"-"&TEXT(TODAY(),"YY"))
Simply put this formula in somewhere lets say in A1 and drag down it will create your needed strings in sequence. please see the file which I attached. Please note that the last two digits are from dynamic year. meaning if you check this formula next year it will be 19 for 2019
if you want to change to static year then replace the below formula to ="RAH/"&(419+ROWS($A$1:A1)&"-18")
="RAH/"&(419+ROWS($A$1:A1)&"-"&TEXT(TODAY(),"YY"))
Thank you Jamil, this worked perfectly!
- You are welcome.
