Step 5: Click on the next option, and in the next option, select the destination cell as B1.

You may need to adjust it as per your data structure.

Step 4: You will see the fixed-width divider vertical line marks (called Break line) in the Data Preview window.

Step 3: Select the Fixed Width option and click on Next.

This would open up the Text to Column Wizard window. Step 2: Go to Data and select the Text to Column excel option (ALT + A + E).Now we will apply the “Fixed width” method of Text to Columns. The below data is in one column, and you need to convert it into 4 columns based on the heading.įrom the above data, we can understand that there are four pieces of information in a single cell, i.e., Hex No., Description. Sometimes your data are in one single column, and you need to divide it into multiple adjacent columns. Let us see how to split the data into multiple columns. If there are initials and the middle names, you need to use a different technique.Įxamples 2: Convert Single Column Data into Multiple Columns Note: This technique is ideal only for first name and last name.

That will split the first name and last name separately. If you want to keep the original data intact, either create a copy or choose a different destination cell.

If you do not select a destination cell, it will overwrite your existing data set with the first name in the first column and last name in the adjacent column. In Step 5, select the destination cell.If you think that there are double/triple consecutive spaces between the names, then select the ‘Treat consecutive delimiters as one’ option. In the next step, first uncheck TAB and select SPACE as the delimiter.Now, make sure Delimited is selected and click on Next.This will open the Convert Excel Text to Columns Wizard. Below are the steps for splitting first name and last name in separate cells –

Sort multiple columns in excel for mac