paste list into excel each word a column

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. 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. If you have a formula that you would like to copy to an entire column in Excel, there is a very easy and fast way of doing this, by using autofill which. 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.

Paste list into excel each word a column