Just trying to bring in a Volumes Dashboard report from IE10 to Excel 2010 (it all worked fine until I my PC was upgraded from IE9/Excel 2007)
When the report is in IE10, I Select All and paste to Excel (as I always have done) and the numbers are not recognised as numbers (there is no convert text to numbers prompt) and seem to have a leading space which Find/Replace can't find and replace.
If I right click in IE10 and Export to Excel, most of the exported data has a weird character preceding it (but which can be found and replaced). Any one know what this character is and how to stop it appearing?
Solved! Go to Solution.
tried again today and yet more (slightly different) random characters
It's a long way around but you could print to pdf/image and use google OCR to recognise the table when uploaded to google docs, I've used it for extracting tables usefull for design from standards.
I've gone with the Ctrl-A from IE10 and Ctrl-V in Excel. I have discovered that the leading blank space is in fact a non breaking space i.e. Alt+0160 so it can now be found and replaced
Pity I can't give myself a Kudo...!!!!!
Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register