結合取等號後面數據 (10249)

日期：


C2:E8=TRIM(MID(SUBSTITUTE(SUBSTITUTE($A2,"&","="),"=",REPT(" ",99)),(COLUMN(A1)*2-1)*99,99))&IF(COLUMN(A1)>=LEN($A2)-LEN(SUBSTITUTE($A2,"=",)),"","&")&D2


留言

張貼留言