What if you came across a scenario where you had to split the text for an unknown delimiter? The previous example made use of predefined delimiters. Now that you know how to convert text to columns in Excel, let us explore a few more scenarios where the text to columns tool can be helpful. Click the Finish button.Īnd now you have the new data set with First name and Last name in 2 separate columns. Step 3: In the last step, change the destination to $B$2 to avoid Excel overwriting the existing data set. Step 2: Choose Space as the denominator, and make sure the ‘Treat consecutive delimiters as one’ option is checked.

Step 1: Make sure Delimited is chosen, and then click Next.

Before separating the text into columns, this wizard involves three steps and asks for some user input.

Then the Convert Text to Columns Wizard will appear.

Text to Columns may be found under Data > Data Tools > Text to Columns.

Select the data set you want to separate.

You can easily split the first name and the last name into separate cells by following these steps. Now your task is to split the text into two columns, namely first name and last name. Split Names into First Name and Last Name And learn how to convert text to columns in Excel.Įxample: 1.

Let's look at some of the cool things you can do with Text to Columns in Excel. You can also use the keyboard shortcut – ALT + A + E to access the text to column wizard. Using this method would open the Convert Text to Columns Wizard. Text to Columns can be accessed by selecting the dataset and then proceeding to Data > Data Tools > Text to Columns. This tool can be helpful when you are importing information from different databases. This blog will teach you how to convert text to columns in Excel. Text to Column | Split Names | Custom Delimiters | Date FormatsĬonverting text to columns is a handy feature in Microsoft Excel.

Convert excel columns to text