Press the Next button.

How to undo the text to columns in excel. Select your data to the range from the first data cell. If column B is blank then list text from Column A. Note that the Table Design tab of the ribbon is a contextual tab and will only be visible when you are clicked in an Excel data table.

Prepare two lists of names in text the separator is comma between each name. Right now Ive created Column C with this formula IFISBLANKB1 A1. In the Text to Columns dialog check Delimited option and click Next to go to next step.

Just select a blank cell then type any data in it then select it and click Data Text to Columns. How to Convert a Text to Columns in Excel. I have a macro which imports data from a mainframe dump text file and performs Text to Columns on the imported data so that formula in the spreadsheet can act on the data.

Obviously the names are split by comma automatically. Click on the Text to Columns icon in the Data Tools group of the Excel ribbon and a wizard will appear to help you set up how the text will be split. 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.

Thats working to get the text from A1 when B1 is blank. How to Undo in Excel Using a Keyboard Shortcut This is the quickest way to undo a previous change. Click on the Insert column option.

Click Data Text to Columns see screenshot. Select the cells that you want to split. Turn off all delimiters and click Finish.