Excel表格一来自列里文字和字母 我只要提取字母 函数公式是多少？

设数据在A列,府球陈见改晶亲现将公式 =SUBSTITUTE(SUBSTITUTE(RIGHT(SUBSTITUTE(A1," "," "),3)," ","")," ","") 粘贴至B1单元格,对准右下角,光标成"+"状时双击,如图: