Coba ketik...=LEFT(A2,FIND(" ",A2)-1)...pada sel B2
=MID(A2,FIND("/",A2)-2,2)...pada sel C2=MID(A2,FIND("/",A2)+1,2)...pada sel D2
kemudian copy ke bawah.
Salam,HK
From: "omeza [email protected] [belajar-excel]"
<[email protected]>
To: [email protected]
Sent: Monday, 23 March 2015, 8:16
Subject: [belajar-excel] Re: Memisahkan alamat yg berbeda2
iya terima kasih Yg kmaren hya salah dalam penulisan..
nangAgus Untuk Kasus berikut ini gmn .kalau sheet Alamat tidak ada Ada RT
DAN RW..berikut saya lampirkan.. 2.xlsx
<http://milis-belajar-excel.1048464.n5.nabble.com/file/n5729671/2.xlsx>
terima kasih
--
View this message in context:
http://milis-belajar-excel.1048464.n5.nabble.com/Memisahkan-alamat-yg-berbeda2-tp5729647p5729671.html
Sent from the Milis Belajar Excel mailing list archive at Nabble.com.
#yiv9645400743 #yiv9645400743 -- #yiv9645400743ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9645400743
#yiv9645400743ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9645400743
#yiv9645400743ygrp-mkp #yiv9645400743hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv9645400743 #yiv9645400743ygrp-mkp #yiv9645400743ads
{margin-bottom:10px;}#yiv9645400743 #yiv9645400743ygrp-mkp .yiv9645400743ad
{padding:0 0;}#yiv9645400743 #yiv9645400743ygrp-mkp .yiv9645400743ad p
{margin:0;}#yiv9645400743 #yiv9645400743ygrp-mkp .yiv9645400743ad a
{color:#0000ff;text-decoration:none;}#yiv9645400743 #yiv9645400743ygrp-sponsor
#yiv9645400743ygrp-lc {font-family:Arial;}#yiv9645400743
#yiv9645400743ygrp-sponsor #yiv9645400743ygrp-lc #yiv9645400743hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9645400743
#yiv9645400743ygrp-sponsor #yiv9645400743ygrp-lc .yiv9645400743ad
{margin-bottom:10px;padding:0 0;}#yiv9645400743 #yiv9645400743actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9645400743
#yiv9645400743activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9645400743
#yiv9645400743activity span {font-weight:700;}#yiv9645400743
#yiv9645400743activity span:first-child
{text-transform:uppercase;}#yiv9645400743 #yiv9645400743activity span a
{color:#5085b6;text-decoration:none;}#yiv9645400743 #yiv9645400743activity span
span {color:#ff7900;}#yiv9645400743 #yiv9645400743activity span
.yiv9645400743underline {text-decoration:underline;}#yiv9645400743
.yiv9645400743attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv9645400743 .yiv9645400743attach div a
{text-decoration:none;}#yiv9645400743 .yiv9645400743attach img
{border:none;padding-right:5px;}#yiv9645400743 .yiv9645400743attach label
{display:block;margin-bottom:5px;}#yiv9645400743 .yiv9645400743attach label a
{text-decoration:none;}#yiv9645400743 blockquote {margin:0 0 0
4px;}#yiv9645400743 .yiv9645400743bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9645400743
.yiv9645400743bold a {text-decoration:none;}#yiv9645400743 dd.yiv9645400743last
p a {font-family:Verdana;font-weight:700;}#yiv9645400743 dd.yiv9645400743last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9645400743
dd.yiv9645400743last p span.yiv9645400743yshortcuts
{margin-right:0;}#yiv9645400743 div.yiv9645400743attach-table div div a
{text-decoration:none;}#yiv9645400743 div.yiv9645400743attach-table
{width:400px;}#yiv9645400743 div.yiv9645400743file-title a, #yiv9645400743
div.yiv9645400743file-title a:active, #yiv9645400743
div.yiv9645400743file-title a:hover, #yiv9645400743 div.yiv9645400743file-title
a:visited {text-decoration:none;}#yiv9645400743 div.yiv9645400743photo-title a,
#yiv9645400743 div.yiv9645400743photo-title a:active, #yiv9645400743
div.yiv9645400743photo-title a:hover, #yiv9645400743
div.yiv9645400743photo-title a:visited {text-decoration:none;}#yiv9645400743
div#yiv9645400743ygrp-mlmsg #yiv9645400743ygrp-msg p a
span.yiv9645400743yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9645400743
.yiv9645400743green {color:#628c2a;}#yiv9645400743 .yiv9645400743MsoNormal
{margin:0 0 0 0;}#yiv9645400743 o {font-size:0;}#yiv9645400743
#yiv9645400743photos div {float:left;width:72px;}#yiv9645400743
#yiv9645400743photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv9645400743
#yiv9645400743photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9645400743
#yiv9645400743reco-category {font-size:77%;}#yiv9645400743
#yiv9645400743reco-desc {font-size:77%;}#yiv9645400743 .yiv9645400743replbq
{margin:4px;}#yiv9645400743 #yiv9645400743ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv9645400743 #yiv9645400743ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9645400743
#yiv9645400743ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9645400743
#yiv9645400743ygrp-mlmsg select, #yiv9645400743 input, #yiv9645400743 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv9645400743
#yiv9645400743ygrp-mlmsg pre, #yiv9645400743 code {font:115%
monospace;}#yiv9645400743 #yiv9645400743ygrp-mlmsg *
{line-height:1.22em;}#yiv9645400743 #yiv9645400743ygrp-mlmsg #yiv9645400743logo
{padding-bottom:10px;}#yiv9645400743 #yiv9645400743ygrp-msg p a
{font-family:Verdana;}#yiv9645400743 #yiv9645400743ygrp-msg
p#yiv9645400743attach-count span {color:#1E66AE;font-weight:700;}#yiv9645400743
#yiv9645400743ygrp-reco #yiv9645400743reco-head
{color:#ff7900;font-weight:700;}#yiv9645400743 #yiv9645400743ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv9645400743 #yiv9645400743ygrp-sponsor
#yiv9645400743ov li a {font-size:130%;text-decoration:none;}#yiv9645400743
#yiv9645400743ygrp-sponsor #yiv9645400743ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv9645400743
#yiv9645400743ygrp-sponsor #yiv9645400743ov ul {margin:0;padding:0 0 0
8px;}#yiv9645400743 #yiv9645400743ygrp-text
{font-family:Georgia;}#yiv9645400743 #yiv9645400743ygrp-text p {margin:0 0 1em
0;}#yiv9645400743 #yiv9645400743ygrp-text tt {font-size:120%;}#yiv9645400743
#yiv9645400743ygrp-vital ul li:last-child {border-right:none
!important;}#yiv9645400743
