i know how to copy and paste, but thats not what i am looking for. i am looking to save as an excel spread sheet. is it possible?
2006-09-26 04:57:20 · 3 answers · asked by jared 1 in Computers & Internet ➔ Other - Computers
Well, if you copy it from Yahoo Yellow Pages and Paste it in Excel, you can save it as an Excel spreadsheet.
Be sure to Paste Special and choose Text or Unicode Text. This takes the formatting from the Internet out.
It seems it would be tedious to paste in information and then arrange it with names in their own column and phones and addresses, etc. all with their own column.
I'm thinking you may want to copy and paste a page into a sheet and then record a macro that re-arranges the data and then you could replay the macro for each sheet pasted in. Be sure you choose relative when you record and then start the macro in the appropriate cell. That way you can add page after page into the same Excel file.
Good Luck.
2006-09-30 04:41:48 · answer #1 · answered by Ken C. 6 · 0⤊ 0⤋
1
2016-12-25 02:18:02 · answer #2 · answered by Anonymous · 0⤊ 0⤋
2
2017-03-08 13:58:56 · answer #3 · answered by ? 3 · 0⤊ 0⤋
Right click in the area where you want to copy, click 'export to MS Excel'
2006-09-26 04:59:54 · answer #4 · answered by Robin A. 3 · 0⤊ 0⤋