i have a field like

ABC_AN_2001006

the next field will be AB_AN_2001007
and so on just add 1

so i need to come up with something that lets me just drag and get the result
is there any other way then concatenate to do this.