Your data will be split into the columns you want. You'd check Other, type an symbol in the box, and Excel could then split the username and domain from email addresses.)Įxcel will then show you a preview of how the finished data will look, and will ask you if the split text is plain text or a date-and if the latter, you can set the correct date format.Įxcel might tell you to select where you want the new columns, in which case, just click on each designated column in your sheet.Ĭlick Finish, and you're done.
You may be tempted to copy and paste the headings to the top of each. Say, for instance, you want the domain names from a list of email addresses. Otherwise the second table will only show the data cells after the split point. (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. Then choose Copy from the Clipboard category. Next, pick the Home tab from the ribbon of the word document. STEPS: In the first place, open Microsoft Word and select the table which you want to copy from Word and paste into excel. For our list of names, we'll check the box beside Space. We can use the Copy and Paste commands to copy a table from word to excel. 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 kommentar(er)
