14,954
edits
Split text by symbol: Difference between revisions
Jump to navigation
Jump to search
no edit summary
m (→Excel Approach) |
No edit summary Tags: Mobile edit Mobile web edit |
||
| Line 31: | Line 31: | ||
==== Approach 1: parse data ==== | ==== Approach 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 | * instruction with screenshots: [https://support.office.com/en-za/Article/split-text-into-different-cells-30b14928-5550-41f5-97ca-7a3e9c363ed7 Split text into different cells - Excel] | ||
==== Approach 2: SUBSTRING_INDEX ==== | ==== Approach 2: SUBSTRING_INDEX ==== | ||