Split Cells in Excel Using Text FunctionsĮxcel Text functions are great when you want to slice and dice text strings. This means that if there are any changes in the original data, you’ll have to repeat the process to get updated results.

The result you get from using the Text to Column feature is static.

While this works well if you want to separate the first name and the last name, in the case of first, middle, and last name it will split it into three parts.

Text to Column feature splits the content of the cells based on the delimiter.

This will instantly split the cell’s text into two different columns. If you want to keep the original data intact, select another cell as the destination. The default destination is A2 and if you continue with this, it will replace the original data set.

I will keep the data format as General as I have text data to split. Step 3 of 3 Text to Columns Wizard: In this step, you can specify the data format and where you want the result.You can see how your result would look like in the Data preview section of the dialog box. Step 2 of 3 Text to Columns Wizard: Select Space as the delimiter and deselect everything else.This would allow you to separate the first name and the last name based on a specified separator (space bar in this case). Step 1 of 3 of Text to Columns Wizard: Make sure Delimited is selected (it is the default selection).In the ‘Data Tools’ group, click on ‘Text to Columns’.Select the cells in which you have the text that you want to split (in this case A2:A7).Here are the steps to split these names into the first name and the last name: Let’s begin! Split Cells in Excel Using Text to Columnīelow I have a list of names of some of my favorite fictional characters and I want to split these names into separate cells.: In this tutorial, you’ll learn how to split cells in Excel using the following techniques:

Split Cells in Excel Using Text Functions.Split Cells in Excel Using Text to Column.

Ms word split cells