In case you have entered some information in a single cell in Excel, and you want to split the text into separate columns then MS Exel has provided an easy way to split the text in a cell. So let us begin with How to Split Text in a Cell in MS Excel 2016?
Step to Split Text in a Cell in MS Excel 2016:
Step 1: First select the cells, whose text you want to split. You can observe in the image below; I have a column Name which comprises the full names of the candidate i.e. first name and last name. I want to separate first name and last name.
Step 3: A Convert Text to Columns Wizard will open. It has three steps. In the first step under Original data type Section select, Delimited as our text is separated with a delimiter, space. Then click Next.
Step 4: In the second step of the wizard, under Delimiters section I have selected Space as my text has space as a delimiter. In case you want to split on the basis of tab, semicolon, comma or other you can choose likewise. You can preview, how your text would be separated in Data preview section. Then click Next.
Next, click in the Destination box and the collapse dialog box (3) button.
Step 6: The dialog box will collapse and then select the cell where you want to place your separated text. You will see that the code of the cell will appear in the Destination box. Then click Expand dialog box(3) button. Click Finish button.