Misal data di A2 :
=TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2," Adj.","")," on",""),"
",REPT(" ",99)),99*(1+2*ISNUMBER(-LEFT(A2))),99))Wassalam, Kid. 2013/6/7 Muhammad HENDRA <[email protected]> > ** > > > Dear para pakar Excel**** > > Mohon bantuannya untuk Extract text dari kolom “Data” **** > > File dengan data tersebut sangat banyak, sehingga cukup menyulitkan saya.* > *** > > ** ** > > Terima kasih atas bantuannya**** > > ** ** > > *Data* > > *Data yang dinginkan* > > 12 o'c Scn Adj. Weld 6-G-E10-11306**** > > Weld**** > > 3 o'c Scn Adj. Weld 6-G-E10-11306**** > > Weld**** > > 6 o'c Scn Adj. Weld 6-G-E10-11306**** > > Weld**** > > 9 o'c Scn Adj. Weld 6-G-E10-11306**** > > Weld**** > > 12 o'c Scn Adj. Weld 6-G-E10-11306**** > > Weld**** > > 3 o'c Scn Adj. Weld 6-G-E10-11306**** > > Weld**** > > 6 o'c Scn Adj. Weld 6-G-E10-11306**** > > Weld**** > > 9 o'c Scn Adj. Weld 6-G-E10-11306**** > > Weld**** > > 12 o'c Scn on Fitting 6-G-E10-11306**** > > Fitting**** > > 3 o'c Scn on Fitting 6-G-E10-11306**** > > Fitting**** > > 6 o'c Scn on Fitting 6-G-E10-11306**** > > Fitting**** > > 9 o'c Scn on Fitting 6-G-E10-11306**** > > Fitting**** > > Scn Tee Extrado 6-G-E10-11306**** > > Tee**** > > Bend Side-1 6-G-E10-11306**** > > Side-1**** > > Bend Extrado 6-G-E10-11306**** > > Extrado**** > > Bend Intrado 6-G-E10-11306**** > > Intrado**** > > Bend Side-2 6-G-E10-11306**** > > Side-2**** > > 12 o'c Scn Stght Pipe 6-G-E10-11306**** > > Stght**** > > 3 o'c Scn Stght Pipe 6-G-E10-11306**** > > Stght**** > > 6 o'c Scn Stght Pipe 6-G-E10-11306**** > > Stght**** > > 9 o'c Scn Stght Pipe 6-G-E10-11306**** > > Stght**** > > Salam Excel**** > > M.Hendra**** > > ** ** > > ** ** > > Best Regards,**** > > M.Hendra**** > > TOTAL E&P INDONESIE East Kalimantan. INDONESIA_FO/INS/OPS_Support : > 53-3063 : Porta Camp Ex.Elnusa 76123**** > > ** ** > > >
