![]() ![]() ( Tip: We have a little box where we can see how the delimiters will affect our current data or, in other terms, how our output will look like). ![]() In the current scenario, it is a space, so click on space. In a delimited section, click on next, and we can see that we have delimiters means the characters by which the text is separated.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 +)
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |