A1=LEFT(SUBSTITUTE(SUBSTITUTE(DEC2BIN(ROW()-1,9),1,2),0,1),3)
B1=MID(SUBSTITUTE(SUBSTITUTE(DEC2BIN(ROW()-1,9),1,2),0,1),4,3)
C1=RIGHT(SUBSTITUTE(SUBSTITUTE(DEC2BIN(ROW()-1,9),1,2),0,1),3)
选定A1:C1
下拉至512行
如图:
其思路是将0到511的十进制数转换成二进制数(000000000到111111111)
然后把1替换成2,把0替换成1,再分3个字符为一组显示。