Hai Rian, Jika ingin memisahkan antara text dengan number, anda bisa menggunakan formula excel "Fungsi Text" seperti LEFT,RIGHT,LEN,MID,FIND Jika dengan VBA anda bisa menggunakan Method "SPLIT" Berikut saya berikan contohnya, mohon maaf jika anda tidak puas dengan contoh yang saya berikan, tapi untuk yang lain mungkin menjadi suatu pembelajaran baru tentang EXCEL
Masalah Puas atau tidak Puas sesuai dengan keinginan, tergantung dari sudut pandang anda untuk mau belajar TerimaKasih. Pada Kamis, 20 Oktober 2016 19:15, "Rian Sutarsa riansuta...@yahoo.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis: Assalamu'alaikum wr.wb. Para Master Mohon pencerahannya mengenai judul diatas pun insyaallah sudah dipahamiSaya coba googling yang menghasilkan ini http://milis-belajar-excel.1048464.n5.nabble.com/belajar-excel-Bagaimana-Memisahkan-Nama-dan-Angka-td5719686.html Hanya saja saya tidak merasa puas karena hasil yang didapat tidak sesuai yang diinginkan.Khusus buat jawaban dari Mr. Kid kalau saja yang diformulakan menghasilkan nama dan bukan inisial saja mungkin tidak akan saya tanyakan disini mohon pencerahannya Mr. Kid karena jawaban anda sudah hampir mendekati apa yang saya maksud Contoh soal : cell:A1 rian123 ingin menjadi cell B1:rian C1:123 #yiv8559631120 #yiv8559631120 -- #yiv8559631120ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8559631120 #yiv8559631120ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8559631120 #yiv8559631120ygrp-mkp #yiv8559631120hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8559631120 #yiv8559631120ygrp-mkp #yiv8559631120ads {margin-bottom:10px;}#yiv8559631120 #yiv8559631120ygrp-mkp .yiv8559631120ad {padding:0 0;}#yiv8559631120 #yiv8559631120ygrp-mkp .yiv8559631120ad p {margin:0;}#yiv8559631120 #yiv8559631120ygrp-mkp .yiv8559631120ad a {color:#0000ff;text-decoration:none;}#yiv8559631120 #yiv8559631120ygrp-sponsor #yiv8559631120ygrp-lc {font-family:Arial;}#yiv8559631120 #yiv8559631120ygrp-sponsor #yiv8559631120ygrp-lc #yiv8559631120hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8559631120 #yiv8559631120ygrp-sponsor #yiv8559631120ygrp-lc .yiv8559631120ad {margin-bottom:10px;padding:0 0;}#yiv8559631120 #yiv8559631120actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8559631120 #yiv8559631120activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8559631120 #yiv8559631120activity span {font-weight:700;}#yiv8559631120 #yiv8559631120activity span:first-child {text-transform:uppercase;}#yiv8559631120 #yiv8559631120activity span a {color:#5085b6;text-decoration:none;}#yiv8559631120 #yiv8559631120activity span span {color:#ff7900;}#yiv8559631120 #yiv8559631120activity span .yiv8559631120underline {text-decoration:underline;}#yiv8559631120 .yiv8559631120attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8559631120 .yiv8559631120attach div a {text-decoration:none;}#yiv8559631120 .yiv8559631120attach img {border:none;padding-right:5px;}#yiv8559631120 .yiv8559631120attach label {display:block;margin-bottom:5px;}#yiv8559631120 .yiv8559631120attach label a {text-decoration:none;}#yiv8559631120 blockquote {margin:0 0 0 4px;}#yiv8559631120 .yiv8559631120bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8559631120 .yiv8559631120bold a {text-decoration:none;}#yiv8559631120 dd.yiv8559631120last p a {font-family:Verdana;font-weight:700;}#yiv8559631120 dd.yiv8559631120last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8559631120 dd.yiv8559631120last p span.yiv8559631120yshortcuts {margin-right:0;}#yiv8559631120 div.yiv8559631120attach-table div div a {text-decoration:none;}#yiv8559631120 div.yiv8559631120attach-table {width:400px;}#yiv8559631120 div.yiv8559631120file-title a, #yiv8559631120 div.yiv8559631120file-title a:active, #yiv8559631120 div.yiv8559631120file-title a:hover, #yiv8559631120 div.yiv8559631120file-title a:visited {text-decoration:none;}#yiv8559631120 div.yiv8559631120photo-title a, #yiv8559631120 div.yiv8559631120photo-title a:active, #yiv8559631120 div.yiv8559631120photo-title a:hover, #yiv8559631120 div.yiv8559631120photo-title a:visited {text-decoration:none;}#yiv8559631120 div#yiv8559631120ygrp-mlmsg #yiv8559631120ygrp-msg p a span.yiv8559631120yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8559631120 .yiv8559631120green {color:#628c2a;}#yiv8559631120 .yiv8559631120MsoNormal {margin:0 0 0 0;}#yiv8559631120 o {font-size:0;}#yiv8559631120 #yiv8559631120photos div {float:left;width:72px;}#yiv8559631120 #yiv8559631120photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv8559631120 #yiv8559631120photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8559631120 #yiv8559631120reco-category {font-size:77%;}#yiv8559631120 #yiv8559631120reco-desc {font-size:77%;}#yiv8559631120 .yiv8559631120replbq {margin:4px;}#yiv8559631120 #yiv8559631120ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8559631120 #yiv8559631120ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8559631120 #yiv8559631120ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8559631120 #yiv8559631120ygrp-mlmsg select, #yiv8559631120 input, #yiv8559631120 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8559631120 #yiv8559631120ygrp-mlmsg pre, #yiv8559631120 code {font:115% monospace;}#yiv8559631120 #yiv8559631120ygrp-mlmsg * {line-height:1.22em;}#yiv8559631120 #yiv8559631120ygrp-mlmsg #yiv8559631120logo {padding-bottom:10px;}#yiv8559631120 #yiv8559631120ygrp-msg p a {font-family:Verdana;}#yiv8559631120 #yiv8559631120ygrp-msg p#yiv8559631120attach-count span {color:#1E66AE;font-weight:700;}#yiv8559631120 #yiv8559631120ygrp-reco #yiv8559631120reco-head {color:#ff7900;font-weight:700;}#yiv8559631120 #yiv8559631120ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8559631120 #yiv8559631120ygrp-sponsor #yiv8559631120ov li a {font-size:130%;text-decoration:none;}#yiv8559631120 #yiv8559631120ygrp-sponsor #yiv8559631120ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8559631120 #yiv8559631120ygrp-sponsor #yiv8559631120ov ul {margin:0;padding:0 0 0 8px;}#yiv8559631120 #yiv8559631120ygrp-text {font-family:Georgia;}#yiv8559631120 #yiv8559631120ygrp-text p {margin:0 0 1em 0;}#yiv8559631120 #yiv8559631120ygrp-text tt {font-size:120%;}#yiv8559631120 #yiv8559631120ygrp-vital ul li:last-child {border-right:none !important;}#yiv8559631120
Split_1.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12