Number To Sequence String

How to convert number to sequence String

Examples
1=A
2=B
3=C
...
27=AA
28=AB
29=AC
...
703=AAA
704=AAB
705=AAC
...
And so on...

Not with letters
I want to do it with a list of characters…

1 Like

Like we ask all others. What have you tried?

2 Likes

You can do it with much(or less) code, there are no problems to do that.

A bit Off-topic:

I actally thought of such a Daily challenge, but decided to make the Daily Challenge #61 about Caesar ciphre.

The idea behind it is almost the same.

I am not able to understand the logic… Getting confused…

18279=AAAA

How to get like this?

1 Like

Anyway i have tried something i don’t know why this don’t work for value inputted greater than 25

Just a suggestion: use the list from csv row text block instead of the make a list and a thousands of strings + a year of work.
:wink:

2 Likes

yes i know, but its only of length 26 that’s why created for more efficiency while testing. :innocent: :upside_down_face:

1 Like

Was this what you wanted

2 Likes

Hey @Boban Yes… This is what I wanted…
Thanks… :smiley:
Please Show Procedure blocks…

@Boban Or we can make a daily challenge
Send me through PM

You should have done it from the beginning :stuck_out_tongue_winking_eye:

Note the last list number

bild

2 Likes

@Boban Please give .apk
I am currently using mobile…

I am making a memory app, and I also did use the list from csv row text block.

It just makes your block look nicer and compact. And also, it’s a huuuge saving of blocks as themselves.

So, I would recommend it to you so hard! :grin:

Yoshi :stuck_out_tongue_winking_eye:

How the .apk will help you?

So he can test it… :man_shrugging:
Note, he is:

1 Like

Sorry the blocks are with in another app, thereby can’t give/make it

Maybe someone else might do it for you

Btw, I’m AFK my self but I can give you this, just download the image and drag it to your project

In this reply it makes clear that this is what he wanted. The next step is to recreate the blocks that Boban provide.

@Boban this is not what I want
Only last character is changing…
Other characters remain as A

The sequence should be like Microsoft EXCEL column names

You never mentioned EXCEL

I gave examples in first post