Add a character at suffix

I want to add continuous series of alphabet as suffix starting from A to ZZ in my index column which start from 1.
Index New Column
1 1A
2 2B
3 3C

26 26Z
27 27AA
28 28AB

and so on.

I get upto Z using
= Table.AddColumn(#"Changed Type", "New Column", each Character.FromNumber([Index] + 64), type text)

See if this is what you had in mind. It will work from A to ZZ, but after that I dont believe it would work. But should at least provide some sort of methodology.

Suffice continous alphabetic.pbix (12.5 KB)

1 Like

Thank for your response. It looks great and resolve my problem.

Thank you :smiley: