uuff, ternyata yg diinginkan hasil = data bertype string / TEXT
=IF(B2="","",IF(AND(CODE(TRIM(B2))>47,CODE(TRIM(B2))<58),
LEFT(TRIM(B2),FIND(" ",TRIM(B2))-1),"-"))
2011/4/20 HerrSoe <[email protected]>
> =IF(B2="","",IF(AND(CODE(TRIM(B2))>47,CODE(TRIM(B2))<58),
> --LEFT(TRIM(B2),FIND(" ",TRIM(B2))-1),"-"))
>
>
> 2011/4/19 abdul hafidz <[email protected]>
> >
> > > gimana yah, caranya memisahkan angka dari text pada sebuah colom
> > contoh :
> > Nama cabang Hasil yg diinginkan
> > 1. 12345 abcdefgh 1. 12345
> > 2. abcdefgh 2. -
> > 3. 12346 abcdefgh 3. 12346
> > 4. abcdefgh 4. -
> > 5. 12347 abcdefgh 5. 12347
> >
> > h4fidz
>
>
