Semoga memberi ide. Regards. Kid.
2010/6/26 Abu Halimah <[email protected]> > > > Mr. Kid, > > Bagaimana untuk memisahkan nama tengah nya "Abdullah *fulan* alan"? > > ------------------------------ > *From:* Mr. Kid <[email protected]> > *To:* [email protected] > *Sent:* Fri, June 25, 2010 11:33:05 PM > *Subject:* Re: ]] XL-mania [[ Memisahkan last name & first name - how ???? > > > > Coba : > =Trim( Right( Substitute( cell_nama , " ", Rept( " ", Len( cell_nama ) ) ), > Len( cell_nama ) ) ) > > Regards. > Kid. > > 2010/6/24 Julie Bernick <julie_bernick@ hotmail.co. > uk<[email protected]> > > > >> >> >> Dear para pakar excel, >> tanya dong bagaimana memisahkan last name jika jumlah huruf masing2 orang >> berbeda. >> contoh: >> 1. Dyah ayu *ekaningtyas* >> 2. Janet *jackson * >> 3. Luna *Maya * >> >> muaciih yahh >> >> salam, >> jb >> >> ------------------------------ >> New Windows 7: Find the right PC for you. Learn >> more.<http://windows.microsoft.com/shop> >> > > > >
re-nama_depan_tengah_belakang.xls
Description: MS-Excel spreadsheet
