15,041
edits
Split text by symbol: Difference between revisions
Jump to navigation
Jump to search
m
→Excel Approach
m (→Excel Approach) |
|||
| Line 29: | Line 29: | ||
=== Excel Approach === | === Excel 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 images: [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 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 ==== | ==== Approach 2: SUBSTRING_INDEX ==== | ||
<table border="1" style=""> | <table border="1" style=""> | ||
<tr style="background-color: #555555; color: #ffffff;"> | <tr style="background-color: #555555; color: #ffffff;"> | ||