C3:J10=IFERROR(TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(MID(LOOKUP(1,0/FIND(T(OFFSET($C$3,,INT((COLUMN(A1)-1)/2)*2)),$I4:$J4),$I4:$J4),FIND("-",LOOKUP(1,0/FIND(T(OFFSET($C$3,,INT((COLUMN(A1)-1)/2)*2)),$I4:$J4),$I4:$J4))+1,99),"p",":"),"$",":"),":",REPT(" ",99)),(MOD(COLUMN(A1)-1,2)+1)*99-98,99)),"")
留言
張貼留言