The interpretation depends on the value of DataType. If more than one character is specified, only the first character of the string is used the remaining characters are ignored.Īn array containing parse information for the individual columns of data. Required if Other is True the delimiter character when Other is True. True to have DataType be xlDelimited and to have the character specified by the OtherChar argument be a delimiter. True to have DataType be xlDelimited and to have the space character be a delimiter. True to have DataType be xlDelimited and to have the comma be a delimiter. True to have DataType be xlDelimited and to have the semicolon be a delimiter. True to have DataType be xlDelimited and to have the tab character be a delimiter. True to have Excel consider consecutive delimiters as one delimiter. Specifies whether to use single, double, or no quotes as the text qualifier. The format of the text to be split into columns. If the range is larger than a single cell, the top left cell is used. Parameters NameĪ Range object that specifies where Microsoft Excel will place the results. TextToColumns ( Destination, DataType, TextQualifier, ConsecutiveDelimiter, Tab, Semicolon, Comma, Space, Other, OtherChar, FieldInfo, DecimalSeparator, ThousandsSeparator, TrailingMinusNumbers)Įxpression A variable that represents a Range object. Thanks for visiting Geek Excel.Parses a column of cells that contain text into several columns. Leave your suggestions in the comment section. In this article, you can clearly understand the steps to Split Cell Contents by Space/Newline/Comma/Period in Excel Office 365 using Kutools with examples. Now, the text and numbers are split and displayed in different columns or rows as shown in the below screenshot.Then, the Split Cells dialog box will pop out to tell you to select a blank cell to display the result.In the Split by section, you need to choose the Text and number option.You need to select the text strings that contain text and numbers.Let’s consider an example data as shown in the below image where you can see the combination of text and numbers.If you have text strings mixed with the text and numbers and you need to split them, do as below steps. Output Split Text and Numbers Mixed in One Cell/Column into Two Cells/Columns/Rows: Now, the selected cells have been split into multiple columns/rows as shown in the below screenshot.Now, the Split Cells dialog box will pop out to tell you to select a blank cell to display the result.You can also specify other delimiters as you wish using the Other text box.Then, you need to choose the separator such as space, newline, semicolon to split the cells.You can also choose the Split to Rows option under the Type section, to split the values into multiple rows.If you want to split the values into multiple columns, then choose the Split to Columns option under the Type section.It will open the Split Cells dialog box.Go to the Kutools Tab, select the Merge & Split option, and choose Split Cells option from the drop-down list.You need to select cell values that you want to split into multiple columns or rows.
Let’s see how to split them in step-by-step instructions.
In the following image, you can see the example of cell values separated by a comma.