ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Exporting to Excel (https://www.excelbanter.com/excel-discussion-misc-queries/61917-exporting-excel.html)

Grady

Exporting to Excel
 
Some computers have an the option "EXPORT TO MICR. EXCEL" in their toolbar
after right clicking on a webpage? I don't have that option but really need
it. Can anyone help?

wjohnson

Exporting to Excel
 

Try the following in "no particular order"
Copy the selection and paste it into excel
Do a save as CSV (Comma Seperated Values)
Do a save as Tab deliminated.

If you try to import and everything goes into column A only. Select
column A and then in the "Font" selection Select "COURIER" and then you
might see where there are "possible" column breaks. If there are - then
- select column A and then go to the menu bar and select DATA - then -
"TEXT TO COLUMNS and follow the popup menus.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=496110



All times are GMT +1. The time now is 10:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com