Increment Alphabet

How to Increment Alphabet

EX1: Input: AC -> Output-> AD
EX2: Input: E -> Output-> F

Just get the index of any column and add 1 to it and use below code.

NumbertoAlphabet.xaml (7.2 KB)

2 Likes

@Sweety_Girl
as already mentioned by others in your other post:

Column as Letter to Int
have a second look on the connect platform or use activity from below as well and write a converter (do while, increase an int counter until Column letter is returned, when passed to the snippet)

(For a macro / invoke vba based approach have a look here: https://www.thespreadsheetguru.com/the-code-vault/vba-code-to-convert-column-number-to-letter-or-letter-to-number)

int to Column Letter:

1 Like

Hey @Sweety_Girl

Please try the workflow given in this post. That really works.

Regards,
Krishna C

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.