Hello, Need to copy a lit of emails into spreadsheet.

Copper Contributor

Is there a quick way to copy a list of email addresses into Excel spreadsheet and it goes into adjacent cells, each address to a cell (right now it is all going into one cell)?

 

4 Replies

Is anyone out there? 

@HeatherS3396 

@HeatherS3396 

It depend on from which source you copy and how addresses are separated in this source. For example, copy from Notepad

image.png

and paste into Excel sheet

 

@Sergei Baklan  Thank you for responding.  I got it done using Excel Help.  First a step on how to copy data into columns.  Don't remember how.  Then found a step to use Paste transpose to get the items into rows, since that is how my spread sheet worked.  Also there was a point where I had to show the thing that separated the list of items (in this case, it was semi-colons).  It worked for now.  I need more training on Excel.  Help got me there though.  Thanks for your idea. 

@HeatherS3396 

If you give a sample from what you copy (link on web page, text file, etc) it will be easier to discuss. Right now that's bit abstract.