14,954
edits
Split text by symbol: Difference between revisions
Jump to navigation
Jump to search
no edit summary
No edit summary |
|||
| Line 26: | Line 26: | ||
=== Excel Approach === | === Excel Approach === | ||
==== 1: parse data ==== | |||
[https://support.microsoft.com/en-us/kb/214261 parse data] ([https://support.microsoft.com/zh-tw/kb/214261 資料剖析]) | |||
==== 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;"> | ||