Excel中截取指定特殊符号之前的数据

2025-05-22 17:45:47

推荐回答（1个）

回答1：

第一个
=LEFT(SUBSTITUTE(A1,",",REPT(" ",99)),FIND(":",SUBSTITUTE(A1,",",REPT(" ",99)))-1)
第二个
=TRIM(LEFT(RIGHT(SUBSTITUTE(A1,",",REPT(" ",99)),LEN(SUBSTITUTE(A1,",",REPT(" ",99)))-50),FIND(":",RIGHT(SUBSTITUTE(A1,",",REPT(" ",99)),LEN(SUBSTITUTE(A1,",",REPT(" ",99)))-50))-1))
第三个
=TRIM(LEFT(RIGHT(SUBSTITUTE(A1,",",REPT(" ",99)),LEN(SUBSTITUTE(A1,",",REPT(" ",99)))-120),FIND(":",RIGHT(SUBSTITUTE(A1,",",REPT(" ",99)),LEN(SUBSTITUTE(A1,",",REPT(" ",99)))-120))-1))