在Excel表里根据怎么残疾证号导出残疾等级？

1、残疾等级

=TEXT(--RIGHT(D2,1),"[dbnum1]")&"级"

2、=TEXT(--RIGHT(D2,1),"[dbnum1]")&"级"含义，text含义是将制定文本变成数值。right最后一个数开始。

3、残疾类别

=LOOKUP(--MID(D2,19,1),{1,2,3,4,5,6,7},{"视力","听力","言语","肢体","智力","精神","多重"})

4、=LOOKUP(--MID(D2,19,1),{1,2,3,4,5,6,7},{"视力","听力","言语","肢体","智力","精神","多重"})

5、残疾等级

=LOOKUP(--MID(D2,19,1),{1,2,3,4,5,6,7},{"视力","听力","言语","肢体","智力","精神","多重"})&TEXT(--RIGHT(D2,1),"[dbnum1]")&"级"

6、=LOOKUP(--MID(D2,19,1),{1,2,3,4,5,6,7},{"视力","听力","言语","肢体","智力","精神","多重"})&TEXT(--RIGHT(D2,1),"[dbnum1]")&"级"