excel如何用函数提取最后一组括号中的内容到另

1个回答

假如数据在A1,在b1输入=LEFT(SUBSTITUTE(A1,"(","/",LEN(A1)-LEN(SUBSTITUTE(A1,"(",""))),FIND("/",SUBSTITUTE(A1,"(","/",LEN(A1)-LEN(SUBSTITUTE(A1,"(",""))))-1)在c1输入=RIGHT(A1,LEN(A1)-LEN(b1)) 下拉...