Increment Letter Serial

[Daniel C]

Hi,

I am not sure if this needs to be a custom function or just a calculation but I am trying to increment a field with a letter in it. I have found a function to increment through the alphabet which is what I need but after "Z" I need to go to AA->AB->AC...AZ->BA and so forth. The original topic with the calculation is here:

http://fmforums.com/forum/topic/32866-increment-the-alphabet/

 

Thanks for any help.

 

Daniel

[comment]

after "Z" I need to go to AA

 

http://www.briandunning.com/cf/399

[Daniel C]

Thanks comment. I don't know how I missed this. I converted my input value to decimal, added 1 and used your custom function. Thanks again.