Convert numbers to pre-defined letters - to create a simple password

[hauwi]

Hi. I have a very basic password system that uses letters to denote numbers. The numbers come from a client's DOB.

I have a date (DOB) field and another field using DATETIME_FORMAT to only show the numbers (DDMMYY). That's all fine.

I would like to have a new field that displays a particular letter for each number - to create a very simple password. Lets say: 1=a, 2=b, 3=c, 4=d, 5=e, 6=f, 7=g, 8=h, 9=i, 0=j

Is there a formula that would do this please?

[Sara · Accepted solution]

Hi, this is the only way that I could think about, Let me know if you have any question 🙂

SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({Number},"0","A"),"1","B"),"2","C"),"3","D"),"4","E"),"5","F"),"6","G"), "7","H"),"8","I"),"9","J")

[hauwi]

Thanks so much. I know it's not pretty - but it works perfectly! 😄