14,954
edits
Split text by symbol: Difference between revisions
Jump to navigation
Jump to search
→Excel Approach
No edit summary Tags: Mobile edit Mobile web edit |
|||
| Line 29: | Line 29: | ||
=== Excel Approach === | === Excel Approach === | ||
==== Approach 1: | Comparison of approaches | ||
<table border="1" class="wikitable sortable"> | |||
<tr> | |||
<th>Approach</th> | |||
<th>Output</th> | |||
</tr> | |||
<tr> | |||
<td>Approach 1: Parse data</td> | |||
<td>'''Multiple''' parts will be returned if the content contains two or more separator characters.</td> | |||
</tr> | |||
<tr> | |||
<td>Approach 2: SUBSTRING_INDEX</td> | |||
<td>Only '''two''' parts will be returned if the content contains two or more separator characters.</td> | |||
</tr> | |||
</table> | |||
==== Approach 1: Pparse 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 screenshots: [https://support.office.com/en-za/Article/split-text-into-different-cells-30b14928-5550-41f5-97ca-7a3e9c363ed7 Split text into different cells - Excel] | * 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] | ||