跳到主内容

Split Text to Columns

Add-in Express

3.5 (19)

Split text into separate columns by any characters

Whenever you want to pull text from a cell into different columns, this add-in will be the perfect online tool.

It allows you to split values by any standard delimiters like spaces and line breaks, or use custom separators you have in your data.

Once you select the column with text and choose your delimiters in the add-in pane, click Split to get new columns with the results to the right of your data. If you have enough blanks there, the add-in will use them and keep your table clear.

You can divide the values by any number of delimiters at once. If these characters follow one another, you can avoid adding an extra column by checking the option to “Treat consecutive delimiters as one”.

Please note that this add-in does not support Excel 2013. It will split your records in Excel online or Excel 2016 in a flash.

外接程序功能
在使用此外接程序时,它
  • 可读取文档并对其作出更改
  • 可通过 Internet 发送数据
  • https://store-images.s-microsoft.com/image/apps.38993.ab6215ed-4d5c-414b-af4e-02cb7a519c25.d9431d8c-8eae-4442-9c37-fee330212983.e34e7cf1-d61c-47f3-87d9-39cac7ee1261.png
    https://store-images.s-microsoft.com/image/apps.38993.ab6215ed-4d5c-414b-af4e-02cb7a519c25.d9431d8c-8eae-4442-9c37-fee330212983.e34e7cf1-d61c-47f3-87d9-39cac7ee1261.png
    https://store-images.s-microsoft.com/image/apps.63616.ab6215ed-4d5c-414b-af4e-02cb7a519c25.d9431d8c-8eae-4442-9c37-fee330212983.b1b813aa-43f2-4808-b75a-38b770f56308.png
    https://store-images.s-microsoft.com/image/apps.22987.ab6215ed-4d5c-414b-af4e-02cb7a519c25.d9431d8c-8eae-4442-9c37-fee330212983.f3cc28e7-9ca7-4bd4-8a2b-dbb4407c5a2a.png
    https://store-images.s-microsoft.com/image/apps.44450.ab6215ed-4d5c-414b-af4e-02cb7a519c25.d9431d8c-8eae-4442-9c37-fee330212983.8dd86a25-7792-4955-99d8-524d0754a80b.png
    https://store-images.s-microsoft.com/image/apps.31019.ab6215ed-4d5c-414b-af4e-02cb7a519c25.d9431d8c-8eae-4442-9c37-fee330212983.c0f0158d-2a8a-467e-8164-858d3759f016.png