TOP BGT rumusnya.
ide BRILLIANT memberi spasi sebanyak 99 dan mengambil angka pertama dengan
dummy "0123456789".
terimakasih pelajaran excel hari ini
--- In belajar-excel@yahoogroups.com, anton suryadi <summon...@...> wrote:
>
> coba,
>
> =VALUE(MID(SUBSTITUTE(A2," ",REPT("
> ",99)),MIN(FIND({0,1,2,3,4,5,6,7,8,9},(SUBSTITUTE(A2," ",REPT("
> ",99)))&"0123456789")),99))
>
>
> >semoga bermanfaat
>
>
>
>
>
>
> ________________________________
> From: zainul ulum <zainul_u...@...>
> To: belajar-excel@yahoogroups.com
> Sent: Tue, January 26, 2010 2:10:26 PM
> Subject: RE: [belajar-excel] (unknown)
>
>
> Masih pakai cell bantu, tanpa macro.
> Bisa mengambil data integer maupun real.
> Kelemahannya: hanya mengambil bilanga pertama dalam string.
>
> ____________ _________ _________ _________ _
> From: belajar-excel@ yahoogroups. com [mailto:belajar-excel@ yahoogroups. com]
> On Behalf Of siti Vi
> Sent: Tuesday, January 26, 2010 1:41 PM
> To: belajar-excel@ yahoogroups. com
> Subject: Re: [belajar-excel] (unknown)
>
>
> wessss... oke banget nih formulanya
>
> sayangnya (sementara) masih mengharuskan data dlm "bilangan"
> harus ada TITIK-nya
>
> XLKJ FOIUR OIUR 999,874,94050 OIUROIU 31 SOIUA OIU
> 150,983,484, 098 ABCDFRGT JDLKJ DLKJ 123 XXQ
> abcdfrt 1234567890 qwertyuio asdfjkl; 345
> menghasilkan error #VALUE
>
> (di problem mas HerrSoe memang contohnya kurang lengkap:
> per sms dia bilang "string bilangan" bisa berupa bilangan bulat.)
>
> tentuna mas HerrSoe dan mas zain saat ini sedang mecari cara
> perbaikannya. ..
>
> karena makro hanya akan dipakai bila formula sudahbenar-2 sulit dibuat.
>
> terima kasih mas zain, trick-nya...
>
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus signature
> database 4805 (20100125) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset. com
>
