LinkBack URL
About LinkBacks
Hi There
I've a document with names and email addresses which I'm trying to paste into excel.
However when I do this it pastes the information across the page and down it, is there any way around this ?
Would really appreciate the help.
Thanks
Dave
Hi There
I've a document with names and email addresses which I'm trying to paste into excel.
However when I do this it pastes the information across the page and down it, is there any way around this ?
Would really appreciate the help.
Thanks
Dave
What type of document is it? In which format?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
It's a a Word document with the names and email addresses.
Which version of Word? How is the data laid out? In a table? Tabs? Columns? How are you trying to copy and paste it in?
It's the latest version of word, the data is laid out with the name and email addresses seperated by a comma.
No rows or columns, and yes I'll try to copy and paste it in. Any help would be great.
OK - so copy and paste it into Excel and it should all end up in one column. All you then need to do is use the Text to Columns feature on the Data menu.
If the Word records with the commas separated values are terminated with a Paragraph Mark for each record, save the Word data as a TXT file. Then open Excel and open the text file and you will be prompted for the delimiter that is being used (just like Text to Columns). Choose the comma and finish and the file will be opened in Excel with each field in its own cell for each record.
If this is an Existing Excel file, you can import the text file by placing the cursor where you want the data to start then click on the Data tab, Get External Data, Text and follow the prompts which are very similar to the above prompts when opening a text file. The data will be imported into the cells as above.
Otherwise do as AliGW instructs.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thanks a mil guys, much appreciated!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks