14,954
edits
Split text by symbol: Difference between revisions
Jump to navigation
Jump to search
→1: parse data
| Line 28: | Line 28: | ||
=== Excel Approach === | === Excel Approach === | ||
==== 1: parse data ==== | ==== 1: parse data ==== | ||
[https://support.microsoft.com/en-us/kb/214261 parse data] ([https://support.microsoft.com/zh-tw/kb/214261 資料剖析]) | [https://support.microsoft.com/en-us/kb/214261 parse data] ([https://support.microsoft.com/zh-tw/kb/214261 資料剖析]) | ||
* instruction with images: [https://support.office.com/en-za/Article/split-text-into-different-cells-30b14928-5550-41f5-97ca-7a3e9c363ed7 Split text into different cells - Excel] | |||
==== 2: SUBSTRING_INDEX ==== | ==== 2: SUBSTRING_INDEX ==== | ||