All words in a paragraph to separate cells?

eryzillah

New Member
Joined
Apr 18, 2012
Messages
3
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!
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
20,585
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
Hi and welcome to the Board
Does each E-mail address appear on a separate line within the cell.
 

eryzillah

New Member
Joined
Apr 18, 2012
Messages
3
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

Well-known Member
Joined
Oct 27, 2005
Messages
20,585
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
OK, that didn't really help.
But try using Text to Columns and using CTRL + J as the delimiter.
 

eryzillah

New Member
Joined
Apr 18, 2012
Messages
3
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

Well-known Member
Joined
Oct 27, 2005
Messages
20,585
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
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 !!
 

Forum statistics

Threads
1,137,154
Messages
5,679,912
Members
419,862
Latest member
Bluewings666

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top