Forum Discussion
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)?
4 Replies
It depend on from which source you copy and how addresses are separated in this source. For example, copy from Notepad
and paste into Excel sheet
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.
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.
Is anyone out there?
