Filter Character in Excel

B2: ACH 1704 152,4 X 243,84

 =TRIM(B2)

E2: ACH 1704 152,4 X 243,84

=SUBSTITUTE(E2,","," ,")

F2: ACH 1704 152 ,4 X 243 ,84

=LEFT(F2,FIND(" ,",F2,1)-1)

G2: ACH 1704 152

------------------------------------
Memfilter angka dalam text

=SUMPRODUCT(MID(0&G2,LARGE(INDEX(ISNUMBER(--MID(G2,ROW($1:$25),1))* ROW($1:$25),0),ROW($1:$25))+1,1)*10^ROW($1:$25)/10)

------------------------------------
Memisahkan text dan angka dalam satu cell excel

=SUBSTITUTE(G2,MID(G2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},G2&1234567890)),8)," "&MID(G2,MIN(FIND({0,1,2,3,4,5,6,7,8,9},G2&1234567890)),8))