Select Comma as the delimiter and uncheck any other delimiters.

How to split text by space/comma/delimiter in excel. Select the cells you need to split and then click Kutools Merge Split Split Cells. The Split Text pane will open on the right side of your Excel window and you do the following. Press the Next button.

Generic formula to split text with delimiter TRIMMIDSUBSTITUTEA1delREPT LENA1N-1LENA11LENA1. In the opening Split Cells dialog box please check the Split to Rows option or Split to Columns options as you need in the Type section. Kutools for Excel - Includes more than 300 handy tools for Excel.

And the Convert Text to Columns Wizard dialog box will open. Split column in excel. 2 go to DATA tab click Text to Columns command under Data Tools group.

3 select the Delimited radio option in the first Convert Text to Columns Wizard dialog box and click Next button. Split text strings into multiple rowscolumns by spacecommadelimiter with Kutools for Excel Above method can only split text strings into multiple columns. You will learn how to separate text by comma space or any other delimiter and how to split strings into text and numbers.

Click on the Text to Columns icon in the Data Tools group of the Excel ribbon and a wizard will appear to help you set up how the text will be split. Kutools for Excel supports another utility of Split Cell utility to help us extract both text before spacecomma and text after spacecomma and output them into different cells. Select Delimited on the option buttons.

Select the range you will split text strings in our case we select the range A1A9 and click Kutools Text Split Cells. Learn how to split text with a delimiter comma space or special characters using a formula based on the TRIM MID SUBSTITUTE and LEN functions. In the Split Cells dialog box select Split to Rows or Split to Columns in the Type section as you need.