知道一个残疾证号（20位数）想通过excel函数提取残疾类别和残疾等级，怎么弄？

Question

如题所述

Answer 1

残疾等级：
=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]")&"级"