知道一个残疾证号(20位数),例如:110221195806010233,想通过excel函数提取残疾类别和残疾等级。
的有关信息介绍如下:残疾等级:=TEXT(--RIGHT(A1,1),"[dbnum1]")&"级"残疾类别:=LOOKUP(--MID(A1,19,1),{1,2,3,4,5,6,7},{"听力","视力","言语","肢体","智力","精神","多重"})合并:=LOOKUP(--MID(A1,19,1),{1,2,3,4,5,6,7},{"听力","视力","言语","肢体","智力","精神","多重"})&TEXT(--RIGHT(A1,1),"[dbnum1]")&"级"