#How to excel split cells into multiple rows or columns how to#
Let us see how to split the data into multiple columns. If there are initials and the middle names, you need to use a different technique.Įxamples 2: Convert Single Column Data into Multiple Columns Note: This technique is ideal only for first name and last name. That will split the first name and last name separately. If you want to keep the original data intact, either create a copy or choose a different destination cell. If you do not select a destination cell, it will overwrite your existing data set with the first name in the first column and last name in the adjacent column.