![]() ![]() 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. In Step 5, select the destination cell.If you think that there are double/triple consecutive spaces between the names, then select the ‘Treat consecutive delimiters as one’ option. In the next step, first uncheck TAB and select SPACE as the delimiter.Now, make sure Delimited is selected and click on Next.This will open the Convert Excel Text to Columns Wizard. Below are the steps for splitting first name and last name in separate cells –
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |