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 <[email protected]>
To: [email protected]
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
