例如:在“987654XXXXXXXXXXXX21”中提取倒数第二位数字“2”,并在另一个单元格中显示汉字“被子”
å ¬å¼å¦ä¸ï¼
=LOOKUP(VALUE(LEFT(RIGHT(A1,2),1)),{0,1,2,3,4,5,6,7,8,9;"","","被å","","","","","","",""})