Excel uses however many columns are necessary to hold the data. In the case of pulling apart names, you should make sure that you use spaces as delimiters.Įxcel pulls apart the cells in your selected range, separating all the text at the delimiter you specified. Specify the delimiters you want Excel to recognize.(In the case of a space between first and last name, the text would be delimited.) Choose whether the text you have selected is fixed width or delimited.The beginning of the Convert Text to Columns Wizard. Excel starts the Convert Text to Columns Wizard.
You can easily use the Text to Columns feature in Excel to pull your data apart.
For instance, the cell contains "Allen Wyatt," but you would rather have the first name in one column, and the last name in the neighboring column to the right. The only problem is the names are all bunched together.
0 kommentar(er)
