However if you want to list all the combinations then that is a more difficult task and I dont have a ready-made solution. Select cell for resultYou now need to select a cell where you want to have the result of possible. To allow permutations with repetitions use the PERMUTATIONA function.
Then all the specified values and separators have been listed into the dialog box see screenshot.
In the List All Combinations dialog box do the operations as below demo shown. To allow permutations with repetitions use the PERMUTATIONA function. Now I want to have all possible combinations of these three cells - like. Click on Formula in Tool Bar 2.