Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can i work on information copied off the web on a worksheet?
Copied and pasted bank statements online to a worksheet and can't get the sum
functions to work. Excel doesn't recognize the characters. It either sums up 0 or gets an error. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can i work on information copied off the web on a worksheet?
Lots of times, when you copy|paste from a web site, you'll get those HTML
non-breaking spaces (char(160)). You can clean them up with formulas, but if you have to do it lots of times (or with lots of data), you may want to use a macro. David McRitchie has a macro that can help clean this: http://www.mvps.org/dmcritchie/excel/join.htm#trimall (look for "Sub Trimall()") If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) jyu wrote: Copied and pasted bank statements online to a worksheet and can't get the sum functions to work. Excel doesn't recognize the characters. It either sums up 0 or gets an error. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copied info from Excel worksheet, but pasted info won't work in fo | Excel Discussion (Misc queries) | |||
Updating macros with copied worksheet information | Excel Discussion (Misc queries) | |||
Protecting Work from being copied | Excel Discussion (Misc queries) | |||
Default of IF statement doesn't work when copied | Excel Worksheet Functions | |||
Formatting information copied and pasted from the WEB to excel | Excel Discussion (Misc queries) |