ikutan ah..
Selalu angka pertama yang ditemui.
=--MID(LEFT(A2,MIN(FIND(ROW(1:10)-1&" ",A2& ROW(1:10)-1&"
"))),MIN(FIND(ROW(1:10)-1,A2& ROW(1:10)-1)),50)
2010/1/26 zainul_ulum <zainul_u...@yahoo.com>
>
>
> 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 <belajar-excel%40yahoogroups.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 <belajar-excel%40yahoogroups.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-ex...@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
> >
>
>
>
