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> >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.
