[belajar-excel] on/off auto covert text to colum???

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

[belajar-excel] on/off auto covert text to colum???

rafael_ari89
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 
Kid
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] on/off auto covert text to colum???

Kid
Administrator
Coba begini :
1. buka excel kosongan
2. 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 excel
5. coba ke windows explorer -> double click file csv dulu gagal rapi






On Fri, Oct 2, 2020 at 2:17 PM Ari Rafael [hidden email]
[belajar-excel] <[hidden email]> 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
>
>
>
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] on/off auto covert text to colum???

rafael_ari89
 mantul Mr.kid, 
terimakasih banyak
Salam-Ari
    On Friday, October 2, 2020, 03:14:22 PM GMT+7, 'Mr. Kid' mr.nmkid@gmail..com [belajar-excel] <[hidden email]> 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 [hidden email] [belajar-excel] <[hidden email]> 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  
Kid
Reply | Threaded
Open this post in threaded view
|

Re: [belajar-excel] on/off auto covert text to colum???

Kid
Administrator
sama-sama

On Fri, Oct 2, 2020 at 4:49 PM Ari Rafael [hidden email]
[belajar-excel] <[hidden email]> wrote:

>
>
> mantul Mr.kid,
>
> terimakasih banyak
>
> Salam-Ari
>
> On Friday, October 2, 2020, 03:14:22 PM GMT+7, 'Mr. Kid'
> [hidden email] [belajar-excel] <[hidden email]> wrote:
>
>
>
>
> Coba begini :
> 1. buka excel kosongan
> 2. 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 excel
> 5. coba ke windows explorer -> double click file csv dulu gagal rapi
>
>
>
>
>
>
> On Fri, Oct 2, 2020 at 2:17 PM Ari Rafael [hidden email]
> [belajar-excel] <[hidden email]> 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
>
>
>