![需要提取前两个单引号之间的文本。](https://linux22.com/image/1412071/%E9%9C%80%E8%A6%81%E6%8F%90%E5%8F%96%E5%89%8D%E4%B8%A4%E4%B8%AA%E5%8D%95%E5%BC%95%E5%8F%B7%E4%B9%8B%E9%97%B4%E7%9A%84%E6%96%87%E6%9C%AC%E3%80%82.png)
610640436 06/10/2014 03:01:05 AM 1 CLOSED Task 'LGSP_J_JOB_GSP_JP_FIN_CO_0000_SumLv3' erred in process 'LGSP_J_SAP_D_D_011' (6534399)
从中,我想要获取前两个单引号之间的文本,以便 Excel 中的输出应该是 LGSP_J_JOB_GSP_JP_FIN_CO_0000_SumLv3
答案1
尝试这个公式:
=MID(A1,FIND("'",A1)+1,FIND("'",A1,FIND("'",A1)+1)-FIND("'",A1)-1)