Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I get rid of symbols that download in data from web
when downloading data from websites using select all, copy, paste into Excel,
I receive symbols and characters some of which can be cut and pasted away. Others such as drop down boxes defy all attempts at removal. Has anyone found a solution? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I get rid of symbols that download in data from web
Try this small macro:
Sub GettingOutOfShape() Dim s As Shape For Each s In ActiveSheet.Shapes s.Delete Next End Sub Macros are very easy to install and use: 1. ALT-F11 brings up the VBE window 2. ALT-I ALT-M opens a fresh module 3. paste the stuff in and close the VBE window If you save the workbook, the macro will be saved with it. To remove the macro: 1. bring up the VBE window as above 2. clear the code out 3. close the VBE window To use the macro from Excel: 1. ALT-F8 2. Select the macro 3. Touch RUN To learn more about macros in general, see: http://www.mvps.org/dmcritchie/excel/getstarted.htm -- Gary''s Student - gsnu200907 "kengs" wrote: when downloading data from websites using select all, copy, paste into Excel, I receive symbols and characters some of which can be cut and pasted away. Others such as drop down boxes defy all attempts at removal. Has anyone found a solution? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Email (LDAP) data download into a single Excel cell - data separat | Excel Worksheet Functions | |||
items chosen to download are NEVER all there after download comple | New Users to Excel | |||
Why do these symbols #### appear after correcting data in a cell? | New Users to Excel | |||
How are symbols inserted in a data validation look-up list? | Excel Worksheet Functions | |||
Symbols in Data Validation List | Excel Worksheet Functions |