In the current example, we will use delimited as the number of characters between the first name and last name is not the same in all the cells. A dialog box appears which has two options:ĭelimited and Fixed width.Select column A as it needs to be separated, and Go to Data Tab and click on the text to column. ( Tip: If we do not insert another column, then the other portion of data will overwrite our data in column B) To insert another column, select column B and right-click on it, and then click insert, or we can use the shortcut key ( Ctrl with +) As we want to split the data in column A into two parts, Insert a column between columns A & B to place the second portion of the text.I want to separate the first name and last name to see how many people are there in the phonebook with the name of Ajay.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |