All words in a paragraph to separate cells?

[eryzillah]

Hi, I have two documents with my customers emails, One is an excel where every email is on a separate line, the other is just a word doc with them together as a paragraph pretty much. When I copy from word & paste in excel ALL the emails go into one cell, how can I make each of them go into their own separate cells?

Thanks!

 

[Michael M]

Hi and welcome to the Board
Does each E-mail address appear on a separate line within the cell.

 

[eryzillah]

Hi and welcome to the Board
Does each E-mail address appear on a separate line within the cell.

Hi Thanks Michael.

In the original file (excel) each email is on a new line, but because I copied & pasted the second lot of emails from a word document it puts the other 300 emails into one line, so instead of it continuing from say 700 to 1000 cells it posts all 300 emails into cell 701

 

[Michael M]

OK, that didn't really help.
But try using Text to Columns and using CTRL + J as the delimiter.

 

[eryzillah]

OK, that didn't really help.
But try using Text to Columns and using CTRL + J as the delimiter.

Sorry I am still learning this, I did what you said and it diddnt work.

I just want a quick was to put all the emails into their own cells with out doing it one by one

 

[Michael M]

OK, that's what my advice was trying to do !!
Did my suggestion make any changes at all ?
AND
As I asked the first time when the email addresses are in the one cell, are they one under the other, or are they broken up in a uneven fashion
Have a look at the 2nd line of my tag and download the HTML Maker. Use it to post a SMALL sample of the cell that is causing the problem !!