首先,建壹個數字與文本的對照表,如圖,F1:G10區域
B1輸入公式=IFERROR(VLOOKUP(A1,$F$1:$G$10,2,0),""),向下拖動填充
然後在A列輸入數字B列即可顯示對應文本。
如果不想建對照表,可以將公式改為
=IFERROR(VLOOKUP(A1,{1,"甲";2,"乙";3,"丙";4,"丁";5,"戊";6,"己";7,"庚";8,"辛";9,"壬";10,"癸"},2,0),"")