Coba....=LEFT(B4;LEN(B4)-1) lalu copy ke bawah. Salam,HK
From: "Salim Jenggot salim.jeng...@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> To: belajar-excel@yahoogroups.com Sent: Tuesday, 18 October 2016, 13:52 Subject: [belajar-excel] Menghilangkan karakter titik di akhir penomoran yg jml karakternya tidak tentu [1 Attachment] Selamat siang para Master Excel, Mohon bantuannya, bagaimanakah cara menghilangkan karakter titik (.) yang berada di akhir penomoran dgn len yg tidak tentu jumlahnya.Contoh seperti file terlampir. atas bantuannya diucapkan terima kasih. Salam hormat,Salim Jenggot #yiv0452448958 #yiv0452448958 -- #yiv0452448958ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv0452448958 #yiv0452448958ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv0452448958 #yiv0452448958ygrp-mkp #yiv0452448958hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv0452448958 #yiv0452448958ygrp-mkp #yiv0452448958ads {margin-bottom:10px;}#yiv0452448958 #yiv0452448958ygrp-mkp .yiv0452448958ad {padding:0 0;}#yiv0452448958 #yiv0452448958ygrp-mkp .yiv0452448958ad p {margin:0;}#yiv0452448958 #yiv0452448958ygrp-mkp .yiv0452448958ad a {color:#0000ff;text-decoration:none;}#yiv0452448958 #yiv0452448958ygrp-sponsor #yiv0452448958ygrp-lc {font-family:Arial;}#yiv0452448958 #yiv0452448958ygrp-sponsor #yiv0452448958ygrp-lc #yiv0452448958hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv0452448958 #yiv0452448958ygrp-sponsor #yiv0452448958ygrp-lc .yiv0452448958ad {margin-bottom:10px;padding:0 0;}#yiv0452448958 #yiv0452448958actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv0452448958 #yiv0452448958activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv0452448958 #yiv0452448958activity span {font-weight:700;}#yiv0452448958 #yiv0452448958activity span:first-child {text-transform:uppercase;}#yiv0452448958 #yiv0452448958activity span a {color:#5085b6;text-decoration:none;}#yiv0452448958 #yiv0452448958activity span span {color:#ff7900;}#yiv0452448958 #yiv0452448958activity span .yiv0452448958underline {text-decoration:underline;}#yiv0452448958 .yiv0452448958attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv0452448958 .yiv0452448958attach div a {text-decoration:none;}#yiv0452448958 .yiv0452448958attach img {border:none;padding-right:5px;}#yiv0452448958 .yiv0452448958attach label {display:block;margin-bottom:5px;}#yiv0452448958 .yiv0452448958attach label a {text-decoration:none;}#yiv0452448958 blockquote {margin:0 0 0 4px;}#yiv0452448958 .yiv0452448958bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv0452448958 .yiv0452448958bold a {text-decoration:none;}#yiv0452448958 dd.yiv0452448958last p a {font-family:Verdana;font-weight:700;}#yiv0452448958 dd.yiv0452448958last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv0452448958 dd.yiv0452448958last p span.yiv0452448958yshortcuts {margin-right:0;}#yiv0452448958 div.yiv0452448958attach-table div div a {text-decoration:none;}#yiv0452448958 div.yiv0452448958attach-table {width:400px;}#yiv0452448958 div.yiv0452448958file-title a, #yiv0452448958 div.yiv0452448958file-title a:active, #yiv0452448958 div.yiv0452448958file-title a:hover, #yiv0452448958 div.yiv0452448958file-title a:visited {text-decoration:none;}#yiv0452448958 div.yiv0452448958photo-title a, #yiv0452448958 div.yiv0452448958photo-title a:active, #yiv0452448958 div.yiv0452448958photo-title a:hover, #yiv0452448958 div.yiv0452448958photo-title a:visited {text-decoration:none;}#yiv0452448958 div#yiv0452448958ygrp-mlmsg #yiv0452448958ygrp-msg p a span.yiv0452448958yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv0452448958 .yiv0452448958green {color:#628c2a;}#yiv0452448958 .yiv0452448958MsoNormal {margin:0 0 0 0;}#yiv0452448958 o {font-size:0;}#yiv0452448958 #yiv0452448958photos div {float:left;width:72px;}#yiv0452448958 #yiv0452448958photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv0452448958 #yiv0452448958photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv0452448958 #yiv0452448958reco-category {font-size:77%;}#yiv0452448958 #yiv0452448958reco-desc {font-size:77%;}#yiv0452448958 .yiv0452448958replbq {margin:4px;}#yiv0452448958 #yiv0452448958ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv0452448958 #yiv0452448958ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv0452448958 #yiv0452448958ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv0452448958 #yiv0452448958ygrp-mlmsg select, #yiv0452448958 input, #yiv0452448958 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv0452448958 #yiv0452448958ygrp-mlmsg pre, #yiv0452448958 code {font:115% monospace;}#yiv0452448958 #yiv0452448958ygrp-mlmsg * {line-height:1.22em;}#yiv0452448958 #yiv0452448958ygrp-mlmsg #yiv0452448958logo {padding-bottom:10px;}#yiv0452448958 #yiv0452448958ygrp-msg p a {font-family:Verdana;}#yiv0452448958 #yiv0452448958ygrp-msg p#yiv0452448958attach-count span {color:#1E66AE;font-weight:700;}#yiv0452448958 #yiv0452448958ygrp-reco #yiv0452448958reco-head {color:#ff7900;font-weight:700;}#yiv0452448958 #yiv0452448958ygrp-reco {margin-bottom:20px;padding:0px;}#yiv0452448958 #yiv0452448958ygrp-sponsor #yiv0452448958ov li a {font-size:130%;text-decoration:none;}#yiv0452448958 #yiv0452448958ygrp-sponsor #yiv0452448958ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv0452448958 #yiv0452448958ygrp-sponsor #yiv0452448958ov ul {margin:0;padding:0 0 0 8px;}#yiv0452448958 #yiv0452448958ygrp-text {font-family:Georgia;}#yiv0452448958 #yiv0452448958ygrp-text p {margin:0 0 1em 0;}#yiv0452448958 #yiv0452448958ygrp-text tt {font-size:120%;}#yiv0452448958 #yiv0452448958ygrp-vital ul li:last-child {border-right:none !important;}#yiv0452448958