不用會寫VBA程式，3個步驟將相同格式的資料合併成一個檔案，一個小技巧教你改變資料類型(數字轉換為文字)Excel 資料清理

<div data-block="true" data-editor="ftafk" data-offset-key="apdph-0-0" style="font-family: "Segoe UI Historic", "Segoe UI", Helvetica, Arial, sans-serif; color: rgb(5, 5, 5); font-size: 15px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"> 不用會寫VBA程式，3個步驟將相同格式的資料合併成一個檔案，

一個小技巧教你改變資料類型(數字轉換為文字)：

03.取得資料夾的資料、04.資料類型轉換_Excel 資料清理

<div data-block="true" data-editor="ftafk" data-offset-key="brf1i-0-0" style="font-family: "Segoe UI Historic", "Segoe UI", Helvetica, Arial, sans-serif; color: rgb(5, 5, 5); font-size: 15px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"> https://youtu.be/P1B-aYTQKvU

<div data-block="true" data-editor="ftafk" data-offset-key="f1clh-0-0" style="font-family: "Segoe UI Historic", "Segoe UI", Helvetica, Arial, sans-serif; color: rgb(5, 5, 5); font-size: 15px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"> 範例與講義下載: https://goo.gl/ytzRxT

<div data-block="true" data-editor="ftafk" data-offset-key="7qbdh-0-0" style="font-family: "Segoe UI Historic", "Segoe UI", Helvetica, Arial, sans-serif; color: rgb(5, 5, 5); font-size: 15px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"> 如果影片對你有幫助，記得訂閱並加入【孫在陽】頻道

<div data-block="true" data-editor="ftafk" data-offset-key="br2en-0-0" style="font-family: "Segoe UI Historic", "Segoe UI", Helvetica, Arial, sans-serif; color: rgb(5, 5, 5); font-size: 15px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"> https://www.youtube.com/c/KemSun/fe...

<div data-block="true" data-editor="ftafk" data-offset-key="3noov-0-0" style="font-family: "Segoe UI Historic", "Segoe UI", Helvetica, Arial, sans-serif; color: rgb(5, 5, 5); font-size: 15px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"> #零基礎學電腦 #OFFICE #電腦教學 #免費學習 #大數據分析 #GOOGLE #VBA自動

<div data-block="true" data-editor="ftafk" data-offset-key="7a45p-0-0" style="font-family: "Segoe UI Historic", "Segoe UI", Helvetica, Arial, sans-serif; color: rgb(5, 5, 5); font-size: 15px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"> 蝦皮賣場:https://shopee.tw/a0829kimo

零基礎學電腦

介紹分享資訊安全及office 各項使用技巧／免費電腦教學

不用會寫VBA程式，3個步驟將相同格式的資料合併成一個檔案，一個小技巧教你改變資料類型(數字轉換為文字)Excel 資料清理

個人資訊

熱門文章

文章分類

最新文章

動態訂閱

文章精選

文章搜尋

參觀人氣