Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
help copying table from Word to Excel?
Someone sent me a table in an email but it didn't include any of the formatting so it's like lines with spaces like:
first name last name user name company name etc
So I want to copy this into Excel, but into cells. Hope that makes sense. Please help!
Thank you!!!!!!!
2 Answers
- AQuestionMarkLv 71 decade agoFavorite Answer
It depends on the format of the email, since it is a table in an email, if it is in html format, you can select the whole table and ctrl+c to copy, open a new spreadsheet and ctrl+v to paste, then the data should get to the right column as shown in the email.
If the data is in text format, try save it to text file, right click on the text file and choose open with MS excel, go through the import wizard, with a little luck, you should get quite a lot of data in the right column.
If the operation of conversion is too hard, i guess you should contact the sender to send in a better formatted version, cause these data might prone to error and lose reliability after heavy manipulation.
- Anonymous4 years ago
the respond is "definite" to all of them, although there are spectacular basic procedures to pass approximately doing it. you could "insert" an Excel table superb right into a be conscious record. you may additionally "link" to it, so any transformations you're making in Excel show up in be conscious, or you would be waiting to reproduction and paste it right this moment. actual the whole Microsoft place of work merchandise have been designed to artwork at the same time so once you could not artwork out how you may perform a little element, ask once you think approximately that possibilities are high there's a skill.