How to use Split Text to Columns for Excel online

The Split Text to Columns for Excel online utility will help you automate splitting text across multiple columns.

  1. Select the column with the records you would like to divide.

    Note. If you select more than one column, the add-in will process values in the leftmost selected column.
  2. Tick off the delimiters that are used for your values:

    • You can pick standard delimiters: space, semicolon, line break, or comma.
    • If the separator you use is not in the list, tick off the Custom checkbox to enter your own. You can type several characters; they are automatically taken in quotes and separated with a comma.
  3. Tip. You can split values by one or by different delimiters at once. E.g. if your values have the following format: "15 Maple street; NY, 25305", select Comma to get ZIP in a different column, or choose Semicolon and Comma to get both, state and ZIP details in separate columns.

    Use a combination of standard and custom delimiters to split such values as "ID 3564645, Name, Package: HGD63" by spaces, commas, and colons at the same time:
    Select the column to split and the delimiters used.

  4. Tick the Treat consecutive delimiters as one checkbox if your data contains a delimiter of more than one character between data fields or if your data contains multiple custom delimiters. The add-in will not create extra empty columns.
  5. Click Split to get the result.
    If there are enough blank cells to the right of the selected column, the add-in will fill them with the results. Otherwise, it will automatically add the necessary number of new columns to the right of your original data:
    Split cells to columns by any characters.


Dear Ablebits,

Thanks for your productivity Split Text add-ins.
I'm using Office 365 on Windows 10 ver 1803.
Somehow I can not typing in the Custom characters box.
Please help me with this issue.

Thanks and best regards.


Dear Dat Nguyen,
Thank you for using our product and for your message! I am sorry you are experiencing such a problem with our add-in.
Please contact us at and send the screenshot of the add-in pane. And also please clarify which symbol you are trying to type. We will help you as soon as we can.

Thank you.


Hi Dat,

How did you solve this problem? thank you. Vig.


Thank you for your comment, Vig.

Please first try to restart your Excel Online and check if the problem persists. If it doesn't help, please email us to with a detailed description of the issue you encountered. Thank you.

Ask a question (posted publicly)

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at
Privacy policy Terms of use Contact us

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.