Forum Discussion
HeatherS3396
Mar 27, 2020Copper Contributor
Hello, Need to copy a lit of emails into spreadsheet.
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)?
HeatherS3396
Mar 27, 2020Copper Contributor
SergeiBaklan 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.
SergeiBaklan
Mar 27, 2020Diamond Contributor
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.