hai Arfah kalau begitu katanya pak guru harus pakai cara tradisional
taruh kursor di kanan data insert name define definisikan SUBS sebagai =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(Sheet1!B2,0,""),1,""),2,""),3,""),4,""),5,""),6,""),7,"") definisikan REMOVENUM sebagai =SUBSTITUTE(SUBSTITUTE(SUBS,8,""),9,"") rumusnya jadi =REMOVENUM anyway, kalau di excel 2007 nggak perlu dibuat seperti ini, bisa langsung. regards, abimono On 11/9/08, Arfah Syarifuddin <[EMAIL PROTECTED]> wrote: > > Bagaimana jika letak textnya gak beraturan. Misalnya AZ123456CV2344GJ..? > > > > tengkiu > > > > *From:* [email protected] [mailto:[EMAIL PROTECTED] *On > Behalf Of *Wieok Susanto > *Sent:* 05 Nopember 2008 18:57 > *To:* [email protected] > *Subject:* Re: ]] XL-mania [[ Extract Text > > >
insert name define.xls
Description: MS-Excel spreadsheet
