How can I enlist permutations of an 8 digit number containing only 1, 2 & 3

[GPratik]

I want to create a List of 8 digit numbers which contains only 1, 2 & 3 in it

[#2 · Accepted solution]

In A1, type =BASE(ROW()-1,3,8). Copy that down to A6561. Then next to that type =SUBSTITUTE(A1,"0","3") and copy down.