mantul Mr.kid, terimakasih banyak Salam-Ari On Friday, October 2, 2020, 03:14:22 PM GMT+7, 'Mr. Kid' mr.nm...@gmail..com [belajar-excel] <belajar-excel@yahoogroups.com> wrote:
Coba begini :1. buka excel kosongan2. file open pilih file csv -> lakukan text to column saat keluar wizard untuk text to column (atur yang rapi)3. setelah hasilnya keluar dalam sheet, lakukan save as pilih excel workbook (xlsx atau yang lainnya)4. tutup semua excel5. coba ke windows explorer -> double click file csv dulu gagal rapi On Fri, Oct 2, 2020 at 2:17 PM Ari Rafael rafael_...@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> wrote: assalamualaikum master, saya ada kendala pada excel di laptop saya, kenapa setiap buka file dengan format CSV data nya selalu tidak rapi (masi format .text)misalnya sya download mutasi dari salah satu bank, ketika sya buka file CSV nya format datanya tidak auto text to colum, sedangkan jika di buka di komputer kantor langsung rapi auto.sya uda coba cari di google cuman gk ktmu, mohon bantuannya dari para master, terimakasih #yiv4514805397 #yiv4514805397 -- #yiv4514805397ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4514805397 #yiv4514805397ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4514805397 #yiv4514805397ygrp-mkp #yiv4514805397hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4514805397 #yiv4514805397ygrp-mkp #yiv4514805397ads {margin-bottom:10px;}#yiv4514805397 #yiv4514805397ygrp-mkp .yiv4514805397ad {padding:0 0;}#yiv4514805397 #yiv4514805397ygrp-mkp .yiv4514805397ad p {margin:0;}#yiv4514805397 #yiv4514805397ygrp-mkp .yiv4514805397ad a {color:#0000ff;text-decoration:none;}#yiv4514805397 #yiv4514805397ygrp-sponsor #yiv4514805397ygrp-lc {font-family:Arial;}#yiv4514805397 #yiv4514805397ygrp-sponsor #yiv4514805397ygrp-lc #yiv4514805397hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4514805397 #yiv4514805397ygrp-sponsor #yiv4514805397ygrp-lc .yiv4514805397ad {margin-bottom:10px;padding:0 0;}#yiv4514805397 #yiv4514805397actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv4514805397 #yiv4514805397activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv4514805397 #yiv4514805397activity span {font-weight:700;}#yiv4514805397 #yiv4514805397activity span:first-child {text-transform:uppercase;}#yiv4514805397 #yiv4514805397activity span a {color:#5085b6;text-decoration:none;}#yiv4514805397 #yiv4514805397activity span span {color:#ff7900;}#yiv4514805397 #yiv4514805397activity span .yiv4514805397underline {text-decoration:underline;}#yiv4514805397 .yiv4514805397attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv4514805397 .yiv4514805397attach div a {text-decoration:none;}#yiv4514805397 .yiv4514805397attach img {border:none;padding-right:5px;}#yiv4514805397 .yiv4514805397attach label {display:block;margin-bottom:5px;}#yiv4514805397 .yiv4514805397attach label a {text-decoration:none;}#yiv4514805397 blockquote {margin:0 0 0 4px;}#yiv4514805397 .yiv4514805397bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv4514805397 .yiv4514805397bold a {text-decoration:none;}#yiv4514805397 dd.yiv4514805397last p a {font-family:Verdana;font-weight:700;}#yiv4514805397 dd.yiv4514805397last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv4514805397 dd.yiv4514805397last p span.yiv4514805397yshortcuts {margin-right:0;}#yiv4514805397 div.yiv4514805397attach-table div div a {text-decoration:none;}#yiv4514805397 div.yiv4514805397attach-table {width:400px;}#yiv4514805397 div.yiv4514805397file-title a, #yiv4514805397 div.yiv4514805397file-title a:active, #yiv4514805397 div.yiv4514805397file-title a:hover, #yiv4514805397 div.yiv4514805397file-title a:visited {text-decoration:none;}#yiv4514805397 div.yiv4514805397photo-title a, #yiv4514805397 div.yiv4514805397photo-title a:active, #yiv4514805397 div.yiv4514805397photo-title a:hover, #yiv4514805397 div.yiv4514805397photo-title a:visited {text-decoration:none;}#yiv4514805397 div#yiv4514805397ygrp-mlmsg #yiv4514805397ygrp-msg p a span.yiv4514805397yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv4514805397 .yiv4514805397green {color:#628c2a;}#yiv4514805397 .yiv4514805397MsoNormal {margin:0 0 0 0;}#yiv4514805397 o {font-size:0;}#yiv4514805397 #yiv4514805397photos div {float:left;width:72px;}#yiv4514805397 #yiv4514805397photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv4514805397 #yiv4514805397photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv4514805397 #yiv4514805397reco-category {font-size:77%;}#yiv4514805397 #yiv4514805397reco-desc {font-size:77%;}#yiv4514805397 .yiv4514805397replbq {margin:4px;}#yiv4514805397 #yiv4514805397ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv4514805397 #yiv4514805397ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv4514805397 #yiv4514805397ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv4514805397 #yiv4514805397ygrp-mlmsg select, #yiv4514805397 input, #yiv4514805397 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv4514805397 #yiv4514805397ygrp-mlmsg pre, #yiv4514805397 code {font:115% monospace;}#yiv4514805397 #yiv4514805397ygrp-mlmsg * {line-height:1.22em;}#yiv4514805397 #yiv4514805397ygrp-mlmsg #yiv4514805397logo {padding-bottom:10px;}#yiv4514805397 #yiv4514805397ygrp-msg p a {font-family:Verdana;}#yiv4514805397 #yiv4514805397ygrp-msg p#yiv4514805397attach-count span {color:#1E66AE;font-weight:700;}#yiv4514805397 #yiv4514805397ygrp-reco #yiv4514805397reco-head {color:#ff7900;font-weight:700;}#yiv4514805397 #yiv4514805397ygrp-reco {margin-bottom:20px;padding:0px;}#yiv4514805397 #yiv4514805397ygrp-sponsor #yiv4514805397ov li a {font-size:130%;text-decoration:none;}#yiv4514805397 #yiv4514805397ygrp-sponsor #yiv4514805397ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv4514805397 #yiv4514805397ygrp-sponsor #yiv4514805397ov ul {margin:0;padding:0 0 0 8px;}#yiv4514805397 #yiv4514805397ygrp-text {font-family:Georgia;}#yiv4514805397 #yiv4514805397ygrp-text p {margin:0 0 1em 0;}#yiv4514805397 #yiv4514805397ygrp-text tt {font-size:120%;}#yiv4514805397 #yiv4514805397ygrp-vital ul li:last-child {border-right:none !important;}#yiv4514805397