Hai Shenly,
Mungkin begini :
=IFERROR(TRIM(MID(LEFT(B2,FIND(" S1",B2&" S1")-1),LOOKUP(9^9,FIND({"DARI","
KE "},B2))+4,99)),"")Wassalam, Kid. 2014/1/21 Shenly <[email protected]> > > > oh ia maaf lupa, ini file contohnya, terlampir.... ^^ > > Salam > Shenly ^^* > > > Pada Selasa, 21 Januari 2014 17:34, "[email protected]" < > [email protected]> menulis: > > sample data nya mana ya? > > > >

