Prev: Best method to populate cell based upon drop down list selecti
Next: Pasting active links in excel
From: basstbone on 5 Mar 2010 17:50
Our company has a large intranet website setup with a bunch of data in it and
it would really be nice to copy and paste from any of there sites into excel
and do stuff to the data. Sort by hire date, remove those pesky spaces I
don't want, etc. The problem (I guess) is javascript/java that was used to
make the webpage? You cut and paste into Excel and it can't do a darn thing.
No way to format (unless you rekey the data), No way for find and replace to
work (at all I think). What gives??? Is there something I'm missing.
Oh...the corp. gurus (haha) also setup a button to export to Excel (but guess
what??) HAHA...same stuff...just like cutting and pasting from the website.
Please help as I have no hair left to pull out :)
>:)
From: Gord Dibben on 5 Mar 2010 18:16
Start acquiring a set af macros to Trim and Clean your data.

Good start is David McRithchie's TRIMALL from

http://www.mvps.org/dmcritchie/excel/join.htm#trimall

For dates you can generally get them to function properly by running through
Data>Text to Columns.

Don't forget the trick of formatting all "numbers" to General, then copying
an unused cell and Paste Special>Add to convert to real numbers.


Gord Dibben MS Excel MVP

On Fri, 5 Mar 2010 14:50:51 -0800, basstbone
<basstbone(a)discussions.microsoft.com> wrote:

>Our company has a large intranet website setup with a bunch of data in it and
>it would really be nice to copy and paste from any of there sites into excel
>and do stuff to the data. Sort by hire date, remove those pesky spaces I
>don't want, etc. The problem (I guess) is javascript/java that was used to
>make the webpage? You cut and paste into Excel and it can't do a darn thing.
> No way to format (unless you rekey the data), No way for find and replace to
>work (at all I think). What gives??? Is there something I'm missing.
>Oh...the corp. gurus (haha) also setup a button to export to Excel (but guess
>what??) HAHA...same stuff...just like cutting and pasting from the website.
>Please help as I have no hair left to pull out :)
>>:)

 | 
Pages: 1
Prev: Best method to populate cell based upon drop down list selecti
Next: Pasting active links in excel