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.

Alex M
Lv 5
Alex M asked in Computers & InternetSoftware · 1 decade ago

Converting a WordPad document into a spreadsheet?

I saved a pretty big chunk of information in a Wordpad document and then realized it would be a lot easier to make changes in a spreadsheet. Is there any way to convert it without having to re-enter everything? It's about 3 pages worth of stuff in a single column but I could fit everything in just one spreadsheet page. I have Windows Vista (major regret) Home Premium if that matters. Thanks.

1 Answer

Relevance
  • Don R
    Lv 5
    1 decade ago
    Favorite Answer

    If you have Excel 2007 you can copy the entire Wordpad doc and Paste it into Excel. It will all go into one column and many rows.

    If you have an earlier version of Excel you can do the same copy/paste but it might be harder to consolidate. You might be able to do it using TEXT WRAP or maybe the CONCATENATE function.

Still have questions? Get your answers by asking now.