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] 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]
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:#ff;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
#66;min-height:62px;overflow:hidden;width:62px;}#yiv4514805397
#yiv4514805397photos div label
{color:#66;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