![]() You need to divide it into multiple adjacent columns. Sometimes your data is in one single column. Let us see how to split the data into multiple columns. You need to use a different approach if there are initials and middle names.Įxamples 2: Convert Single Column Data into Multiple Columns Note: This technique is ideal only for first names and last names. Click on “FINISH.” That will split the first name and last name separately. ![]() If you want to keep the original data intact, create a copy or choose a different destination cell. If you do not select a destination cell, it will overwrite the existing data set with the first name in the first column and the last name in the adjacent column. If you think of double/triple consecutive spaces between the names, choose the “Treat consecutive delimiters as one” option. In the next step, uncheck “TAB” and select “SPACE” as the delimiter.Now, make sure “Delimited” is selected and click on “Next.”.Then, press “ALT + A +E.” It will open the “Convert Text to Columns Wizard.”.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |