公司或學校的資料中常常會有單欄的資料，非常不方便使用。
整理資料時，如果用複製貼上則曠日廢時。
如果有辦法自動將A欄中的資料轉換成多欄資料，以方便篩選、查詢與統計。
是不是很美好呢?
原始資料：單欄資料
- Apr 10 Mon 2017 16:16
-
EXCEL學習- 單欄資料轉成多欄資料 (一)
- Apr 16 Sun 2017 14:24
-
EXCEL學習- 單欄資料轉成多欄資料 (二)
上一篇文章 EXCEL學習- 單欄資料轉成多欄資料 (一) 初步說明了將單欄資料轉成多欄資料
本文將進一步說明如何銷掉每個儲存格中多出來的 姓名：、電話：、手機：、地址：
思考邏輯
1. 每一個欄位中要消除的資料最後一個字都是 "：" 。所以可以用FIND函數找出 "："的位址。
2. 包含 "："及之前的文字要消除，可以用空格 " " REPLACE掉
- Apr 10 Mon 2017 22:51
-
6 Ways to Look More Confident During a Presentation
6 Ways to Look More Confident During a Presentation
六種讓簡報看起更自信的方法
by Kasia Wezowski
APRIAL 06, 2017
Several years ago, colleagues and I were invited to predict the results of a start-up pitch contest in Vienna, where 2,500 tech entrepreneurs were competing to win thousands of euros in funds. We observed the presentations, but rather than paying attention to the ideas the entrepreneurs were pitching, we were watching the body language and micro expressions of the judges as they listened.
1
