excel找到某字符最后出现的位子并取前面的内容

技术2022-07-11 117

=LEFT(D1,LEN(D1)-LEN(TRIM(RIGHT(SUBSTITUTE(D1,"指定字符",REPT(" ",LEN(D1))),LEN(D1))))-2)

Processed: 0.017, SQL: 9