Anagram on Excel

Hello
This is a recurring topic that has had many responses. Very competent contributors on this site will be able to offer you some very effective solutions, but in the meantime, I can modestly suggest a solution (which, from a programming perspective, is not the most efficient, but it has the merit of working).
Enter the characters to be permuted in A1 (maximum 12 characters), then click the button. It is obvious that the more characters there are, the longer the search time for permutations will be.
In the meantime, try better proposals.
https://www.cjoint.com/c/CIishRLh5pr
Have a good evening
Best regards

Hello.

If we can? With a macro written in VBA, perhaps...

With traditional methods, I'm afraid there's no other way than the one you're using with paper and pencil!
Excel can then only help you
1) to calculate the number of possible results, namely
=PERMUTATION(LEN(A1),LEN(A1))
and if A1 contains "zut" the result of the calculation is 6 (that is, zut-ztu-utz-uzt-tzu-tuz)
But if A1 contains "cinq" there are already 24 possibilities; if A1 contains "douze" there are 120 solutions... and when we get to "cordialement" there are 479,001,600 anagrams to find!
2) just to write all of this neatly

Retirement is great! Especially in the Caribbean... :-)
☻ Raymond ♂

Hello everyone

With my old Excel 2003 I can't open the file from frenchie83 ....
Another suggestion might be different but still VBA
https://www.cjoint.com/?3IitOSd1E7H

Have a good end of the day ... and good afternoon to Raymond (the lucky one)

That's exactly what I want to do with Excel, but I'm not used to using it, so I don't understand much. I just want to program Excel in such a way that if I type a word, it gives me a list of all possible anagrams.

I believe you haven't read (or understood) what I wrote ... so let me summarize:
Almost impossible ...
... unless you know VBA language, to create a macro.

--
Retirement is nice! Especially in the Caribbean ... :-)
☻ Raymond ♂

Good evening everyone,

It is entirely possible to solve your problem without using VBA.

All it "takes" is generating the permutations in lexicographic order by starting, for example, from a Kivabian algorithm (the one I used comes from the book by Berstel, Pin, and Pocchiola: Mathematics and Computer Science) and transposing it into Excel/spreadsheet.

Naturally, anything combinatorial escalates quickly, and the number of anagrams becomes unmanageable.
So, I limited the number of letters to 8 (still 40,320 permutations).

Then, I worked on the indices (from 1 to 8) to list the permutations from 12345678 to 87654321.
From there, it is enough to use the INDEX() function to obtain the alphabetical equivalent of the permutations.

However, the formulas are not simple as they perform the work of an algorithm.
Here is a workbook https://www.cjoint.com/c/CIjbU1S01km that lists the anagrams of an 8-letter word.
For size reasons, I only kept the first 40 rows. You will need to copy down (up to 40322) to have a complete table.

You will need to modify it a bit for it to work with words of shorter lengths.

Best regards.