![]() ![]() 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 |