| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Puzzled about javascript interfering with functions and formatting
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 :) :) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Puzzled about javascript interfering with functions and formatting
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 :) :) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Puzzled about javascript interfering with functions and format
YOU WIN ! :)
Thank you :) My other question is...why when I called Microsoft couldn't they figure it out??? "Gord Dibben" wrote: 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 :) :) . |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Puzzled about javascript interfering with functions and format
The answer to that is probably why MSFT touts MVPs like Gord as providing
"Independent Experts - Real world answers." I would hazard a guess that Gord has encountered this type of situation before and dealt with it personally, or else he's seen similar problems asked about here and took a note of where to begin finding a solution. "basstbone" wrote: YOU WIN ! :) Thank you :) My other question is...why when I called Microsoft couldn't they figure it out??? "Gord Dibben" wrote: 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 :) :) . |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Puzzled about javascript interfering with functions and format
On 3/5/2010 6:25 PM, JLatham wrote:
The answer to that is probably why MSFT touts MVPs like Gord as providing "Independent Experts - Real world answers." I would hazard a guess that Gord has encountered this type of situation before and dealt with it personally, or else he's seen similar problems asked about here and took a note of where to begin finding a solution. "basstbone" wrote: YOU WIN ! :) Thank you :) My other question is...why when I called Microsoft couldn't they figure it out??? "Gord Dibben" wrote: 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 :) :) . Gord is one of the star performers among MVP's! Bill |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting Excel cell through Javascript | Excel Discussion (Misc queries) | |||
| Page Protection interfering with Hiding Rows | Excel Worksheet Functions | |||
| Office XP SP3 interfering w/ Excel | Excel Discussion (Misc queries) | |||
| puzzled | Excel Worksheet Functions | |||
| EASY ONE ! using countIF.. puzzled | Excel Discussion (Misc queries) | |||
Linear Mode
