Prepare two lists of names in text the separator is comma between each name.

How to undo the text to columns in excel. And EXCEL now has a refreshed setting -- thus not requiring to close it and restarting it. Split names into five different columns by Text to Columns function. Using the keyboard shortcut CTRLZ on a PC or CMDZ on a Mac you can step back one level to undo the last change that you made to your spreadsheet.

Text To Column option in excel is available in the Data menu tab under the Data Tools section which is used for separated text available in a cell or column to the columns by splitting them with different criteria. Just select a blank cell then type any data in it then select it and click Data Text to Columns. Select the cells that you want to split.

Obviously the names are split by comma automatically. Text to Columns in Excel. Select any cell with a value and run Data Text-to-Columns Delimited.

Right-click on the left-most column. Pressing the shortcut again will take you one step further back and so on. So if this is not what one wants one can clear the DATAText_to_column settings -- by typing any text character in a cell then activating DATAtext_to_columns then say choose the Delimited option and clear all of the Delimiters setting boxes.

Click on the Insert column option. Subsequent pasting of information into a worksheet will not use remembered delimiters since there are none. Select Comma as the delimiter and uncheck any other delimiters.

Turn off all delimiters and click Finish. How to Convert a Text to Columns in Excel. Press the Next button.