abcdef顺序不变,大小写排列组合,使用excel公示的话怎样编写??_百度知...答:A1写公式:=TEXT(DEC2BIN(ROW()-1),"000000")下拖复制到A64!B1写公式:=IF(-MID(A1,1,1),"A","a")&IF(-MID(A1,2,1),"B","b")&IF(-MID(A1,3,1),"C","c")&IF(-MID(A1,4,1),"D","d")&IF(-MID(A1,5,1),"E","e")&IF(-MID(A1,6,1),"F","f")下拖...