In the dataset, we see the names of some English literary writers. Split One Cell into Two Using Text to Columns Feature For the purpose of demonstration, I have used the following sample dataset.ġ. Moreover, I should not mention that I have used the Microsoft Excel 365 version for this article you can use any other version according to your convenience. Now, we have to split the cell of column B into two columns, e.g., first name and last name. Here, we have a dataset where column B mainly consists of full names. In this part, I will show you five useful methods to split one cell into two in Excel. Conclusion How to Split One Cell into Two in Excel: 5 Useful Methods
