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 [email protected]
[belajar-excel]" <[email protected]> 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
