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.
    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.

  3. 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.
  4. 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.

Responses

Zack says:
November 7, 2020 at 4:28 pm

I just installed this for Office Online, and the split doesn't seem to work at all, even though my selected column definitely has the delimiter characters that I selected. The button just does nothing. Any idea why?

Mary Trifuntova (Ablebits Team) says:
November 8, 2020 at 8:42 am

Hello Zack,

Thank you for your comment. It looks like you're using our old Split Text tool that we no longer update and support. Instead, we introduced Text Toolkit that can be used in any Excel, whether desktop or online, including Excel for Windows, Excel for Mac and Excel on the web. This package includes a Split Text tool that will work perfectly for your task. Feel free to install Text Toolkit right from the Store: https://appsource.microsoft.com/en-us/product/office/WA200001792?src=office

Our online docs will help you quickly start using Split and other tools. The entry point is here: https://www.ablebits.com/docs/excel-text-toolkit-intro/

Clayton King says:
March 14, 2020 at 7:12 pm

I have exactly the same issue. I am not able to directly type in the Custom delimeter field. I can paste, but not type in it. That said, when selecting the cells I want to split, it's as if Ablebits is ignoring my pasted custom delimeter. I'm told no cells were effected.

Ekaterina Pechyonkina (Ablebits Team) says:
March 15, 2020 at 12:20 pm

Hello Clayton,

Thank you for contacting us. Please tell me what version of the add-in you use, online or desktop one. Thank you.

Dat Nguyen says:
February 19, 2019 at 4:03 am

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.

Post a comment

Seen by everyone, do not publish license keys and sensitive personal info!

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 support@ablebits.com.