如何快速提取

老军医

如何提取“[97]刘佳萍   320902200901230026”中的姓名，注意：姓名前后有或多或少的空格

王梓霁

=MID(TRIM(A1),6,3)

目标明确

=CONCAT(IF(MID(A1,ROW(1:99),1)>"z",MID(A1,ROW(1:99),1),""))

王嵬

=TRIM(MID(SUBSTITUTE(TRIM(A1)," ",REPT(" ",10)),11,10))

一路上有你们

=TRIM(MID(SUBSTITUTE(A1,"",""),FIND("]",SUBSTITUTE(A1,"",""),1)+1,3))

崂知源

请参考：
=TRIM(MID(A1,FIND("]",A1)+1,LEN(A1)-FIND("]",A1)-18))