Iki.ki ------Original Message------ From: SUYONO [email protected] [belajar-excel] Sender: [email protected] To: [email protected] ReplyTo: [email protected] Subject: RE: [belajar-excel] Menghilangkan karakter Sent: Sep 18, 2014 17:01
Sore Pa Luthfi Kalau ip yang berubah hanya sub paling belakang coba pake rumus ini. =LEFT(A1,LEN(A1)-(LEN(A1)-11)) Salam, Suyono From: [email protected] [mailto:[email protected]] Sent: Thursday, September 18, 2014 11:21 AM To: [email protected] Subject: [belajar-excel] Menghilangkan karakter bismillah,.. rekans,... mohon bantuannya dunks, lagi bikin data ip address nih, tp mau ambil 3 sub didepan aja dari semua ip address yang ada. contoh, 10.212.233.144 nanti hasilnya: 10.212.233. masalahnya kan kalo ip itu tiap sub terakhir dari satu digit sampe 3 digit, kalo pasti 3 kalo pasti 3 digit maka saya pake formula: =LEFT(CELL,LEN(CELL)-3) Mohon masukannya yaa rekan-rekan,... maturnuwon,.. -- Luthfi Arifianto belajar Excel Posted by: SUYONO <[email protected]> Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (2) Improvements in Yahoo Groups Search Searching for new groups to join is easier than ever. We've honed our algorithm to bring you better search results based on relevance and activity. Try it today! ============================================================ Pojok Lowongan Kerja yang disediakan milis : http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html *** Posting lowongan kerja : ke link tersebut dan klik New Topic ============================================================ bergabung ke milis (subscribe), kirim mail kosong ke: [email protected] posting ke milis, kirimkan ke: [email protected] berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages melihat file archive / mendownload lampiran : http://www.mail-archive.com/[email protected]/ atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/ menghubungi moderators & owners: [email protected] keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel- Powered by Telkomsel BlackBerry®
