1 / 9

Another way

Another way. Here is a different, possibly better way to deal with the problem of the height (e.g. 5-11) being converted to a date (e.g. May 11, 2004) when copied to Excel. We copy to Word, do a replacement, then copy to Excel. Copy and paste tabled data from website to Microsoft Word.

jeri
Download Presentation

Another way

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Another way • Here is a different, possibly better way to deal with the problem of the height (e.g. 5-11) being converted to a date (e.g. May 11, 2004) when copied to Excel. • We copy to Word, do a replacement, then copy to Excel.

  2. Copy and paste tabled data from website to Microsoft Word.

  3. Go to Edit/Replace

  4. Replace 5- with 5, and 6- with 6,. We could simply replace – with , but we want to make sure there are no –’s that we would want to keep. If there were phone numbers or zip codes even this precaution would be good enough.

  5. Copy from Word and paste to Excel.

  6. Save As a CSV file.

  7. Close the CSV and open it in Notepad.

  8. Replace “ with nothing.

  9. Save and open in Excel. Re-label columns and proceed similar to before.

More Related