C2=TRIM(LEFT(SUBSTITUTE(MID(SUBSTITUTE(SUBSTITUTE(A$1,"、",";"),";",REPT(" ",199)),ROW(A1)*199,199),"公司","公司"&REPT(" ",199)),199))
另解=IFERROR(TRIM(LEFT(SUBSTITUTE(MID(A$1,FIND("!",SUBSTITUTE(SUBSTITUTE(A$1,"、",";"),";","!",ROW(A12)))+1,19),"公司","公司 "),19)),"")
留言
張貼留言