Say, for instance, you want the domain names from a list of email addresses. (Check Other if your character is not listed, then type that character in the box. If you have a list of comma-separated values, check the Comma option instead. For our list of names, we'll check the box beside Space. The Delimited option should be checked by default-this specifies that the text you want to separate uses spaces, tabs, or other delimiters. Select the column with the text you want to split.Ĭlick the Data tab in the top menu, and click Text to Columns-you should see it around the middle of the toolbar.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |