Converting Number to Corresponding Alphabet Letter

I have come across many solutions on how to effectively convert a letter into its corresponding number......, but I am having a hard time figuring how to do the opposite. Attached is a simple workflow where my intent is to identify the next letter in the alphabet. I have converted the letter into its corresponding number and then +1. Now I am not sure how to then convert that number back to its corresponding letter of the alphabet.

I also don't care about 'z' or 'Z' where the next corresponding letter is "a' or "A'. I have filtered those out and hard coded the value.

I'm hoping this is a simple request, but perhaps not a common one. Thanks in advance for anyone's help!

Next_Letter_Workflow.yxmd

Workflow

Preparation

Accepted answers

jdunkerley79

Probably the most direct way is the CharFromInt and CharToInt functions. Something like:

CharFromInt(
Mod(CharToInt(Uppercase([Letter]))-64,26)+65
)

These functions will switch to and from the ASCII code (A=65, B=66,...) for the letter.

Attached a quick sample

Compute Next Letter.yxmd

All comments

jdunkerley79

Probably the most direct way is the CharFromInt and CharToInt functions. Something like:

CharFromInt(
Mod(CharToInt(Uppercase([Letter]))-64,26)+65
)

These functions will switch to and from the ASCII code (A=65, B=66,...) for the letter.

Attached a quick sample

Compute Next Letter.yxmd

vizAlter

Hi @zaslam — Try this solution... it will give you an idea:

If it resolves your query please mark it "Solved" or "Solved" with a Like. This will help other users find the same answer/resolution. Thank you.

Converting Number to Corresponding Alphabet Letter.yxmd

atcodedog05

Hi @zaslam ,

Since it doesnt matter whether its lower or upper i have converted all to lower. And built the logic around it.

Use this in formula

IF CharToInt(LowerCase([Letter]))=122 THEN CharFromInt(97)

ELSE CharFromInt(CharToInt(LowerCase([Letter]))+1) ENDIF

Hope this helps : )

If this solves your task please mark the post as solution

Alpha.yxmd

zaslam

Thanks! All of these solutions worked well, but varied in approaches. The key to all of these for me was effectively using the ChartoInt and then the CharFromInt functions.

Thanks everyone!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15872

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703