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.

How to split text by space/comma/delimiter in excel. In this example the goal is to split a text string at the underscore _ character. Generic formula to split text with delimiter TRIMMIDSUBSTITUTEA1delREPT LENA1N-1LENA11LENA1. Please do as follows.

Select the range you will split text strings in our case we select the range A1A9 and click Kutools Text Split Cells. The formulas used to do this are in two separate 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.

Split text strings into multiple rowscolumns by spacecommadelimiter with Kutools for Excel Above method can only split text strings into multiple columns. Expand the Split by character group and select one of the predefined delimiters or type any other character in the Custom box. Select Comma as the delimiter and uncheck any other delimiters.

Select the range you will split text strings in our case we select the range A1A9 and click Kutools Text Split Cells. Kutools for Excel - Includes more than 300 handy tools for Excel. 1 select the range of cells B1B5 that you want to split text values into different columns.

2 go to DATA tab click Text to Columns command under Data Tools group. The tutorial explains how to split cells in excel using formulas and the split text feature. Select Delimited on the option buttons.

You will learn how to separate text by comma space or any other delimiter and how to split strings into text and numbers. 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. Select the cells you need to split and then click Kutools Merge Split Split Cells.