EXCEL提取单元格内右起第三个和第二个空格中间的数据

2024-11-25 20:46:55
推荐回答(1个)
回答1:

输入以下公式

=TRIM(MID(SUBSTITUTE(A2," ",REPT(" ",100)),(LEN(A2)-LEN(SUBSTITUTE(A2," ",""))-2)*100,100))

详见附图示例