coba juga,
=--MID(LEFT( A3,LOOKUP(99,FIND((ROW(1:10)-1)&" ",A3&"
"))),MIN(FIND(ROW(1:10)-1,A3&ROW(1:10)-1)),50)
>semoga bermanfaat
________________________________
From: Mr. Kid <mr.nm...@gmail.com>
To: belajar-excel@yahoogroups.com
Sent: Tue, January 26, 2010 11:03:40 PM
Subject: Re: [belajar-excel] Re: (unknown)
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_ulum@ 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, anton suryadi <summon...@.. .> wrote:
>>>
>>> coba,
>>>
>>> =VALUE(MID(SUBSTITU TE(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_ulum@ ...>
>
>>> 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
>>>
>
>
