Snasui Excel Forum

ต้องการแยกข้อมูล package MbpsUp MbpsDown Month Price ครับมีวิธีแยกไหมครับ

แยกได้ประมาณนึงนะ

G2 column ช่วย
=TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(B2)," m","m")," k","k"),"th","th ")," ",REPT(" ",90)),MAX(1,FIND("mb",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(B2)," m","m")," k","k"),"th","th ")," ",REPT(" ",90)))-9),9))

C2
=IFERROR(LEFT(G2,FIND("/",G2&"/")-1),"")

D2
=IFERROR(MID(G2,FIND("/",G2)+1,3),"")

E2
=IFERROR(TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(B2),"mb",),"em",),"/"," "),FIND("m",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(B2),"mb",),"em",),"/"," "))-2,2)),"")

F2
=IFERROR(TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(B2)," m","m")," k","k"),"th","th ")," ",REPT(" ",90)),FIND("0k",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(B2)," m","m")," k","k"),"th","th ")," ",REPT(" ",90)))-90,91)),TRIM(RIGHT(SUBSTITUTE(B2," ",REPT(" ",20)),20)))

ขอบคุณครับ