将括号里面的人名去掉 (11485)

日期：

(2007版) B4:C10=SUBSTITUTE(A4,"（"&TRIM(MID(SUBSTITUTE(SUBSTITUTE(A4,"（",REPT(" ",99)),"）",REPT(" ",99)),99,99))&"）",)



留言

張貼留言