正方形 依字母數 (13189)

C3:L11=IF(OR(ROW(A1)=LEN($A$2)^{0,1}*(COLUMN(A1)<=LEN($A$2)),COLUMN(A1)=LEN($A$2)^{0,1}*(ROW(A1)<=LEN($A$2))),MID($A$2,IF(COLUMN(A1)+ROW(A1)-LEN($A$2)-1<=0,COLUMN(A1)+ROW(A1)-1,ABS(COLUMN(A1)-ROW(A1))+1),1),"")



留言