C2:F8=IF(COLUMN(A1)>(LEN($A2)-LEN(SUBSTITUTE($A2," ",))+1)*2,"",IF(COLUMN(A1)=1,LEFT(A2,FIND(":",A2)),"")&TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A2,"%"," "),":"," ")," ",REPT(" ",99)),CHOOSE(COLUMN(A1),3,2,5,4)*99-98,99))&IF(MOD(COLUMN(A1),2),"","% ")&D2)
留言
張貼留言