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?
>
>
>    
>

Kirim email ke