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
DataText to Columns.

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


Gord Dibben MS Excel MVP

On Fri, 5 Mar 2010 14:50:51 -0800, basstbone
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 :)
:)