Re: How can I paste a table of data into Excel from a MSIE / web browser?

Try right click in the area of the table and see if
"import to excel" is an option

--
Don Guillett
SalesAid Software
donaldb@xxxxxxx
"ship" <shiphen@xxxxxxxxx> wrote in message
news:1116414713.648028.107110@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hi
>
> Is there any way to paste out of a table on a web page,
> *straight* into msExcel2002, but without taking microsoft all the
> friggin Micro$oft formatting with it.
>
> I just want the data, but I also want the table
> structure!
>
> Copying out of Firefox into Excel and table structure
> is lost - it just splurges out in a single line; and copying out of
> MSIE (latest) and either all sorts of formatting comes with it, or the
> table structure is lost.
>
> So at present I paste out of MSIE into Excel, save as tab-delimited
> text. Close. Re-open. Have to scroll down to find the correct format
> out of drop-down list, next, next and then finish.... All do-able but
> I'm getting very bored of having to KEEP do so many steps!
>
>
>
> Ship
> Shiperton Henethe
>
> P.S.
> -Does Excel2003 have a better solution?
> -Or maybe there's a pluggin I can download from somewhere?
>
> [END]
>


.

Relevant Pages

  • Re: Excel-Office 2008 for Mac
    ... Excel with capabilities of Print Preview in Word. ... view which allowed formatting changes plus other sheet editing & page break ... adjustment but didn't allow margin changes or other Setup options without ... programmers list of Important Things To Maintain When Upgrading Software, ...
    (microsoft.public.mac.office.excel)
  • RE: Excel Automation
    ... spreadsheet works PERFECTLY. ... The only issue that I have is that the EXCEL ... All of the formatting worked perfectly ... > Dim strRightRange As String ...
    (microsoft.public.access.modulesdaovba)
  • Re: Merging values into Word documents
    ... Merging a letter with currency amount fields must happen very frequently. ... bother to develop a cell format capability to display as Currency if any ... If Word's mergefields are showing the values to 4 decimal places, that's because the values are *stored* that way in Excel. ... Whether the formatting differences between Word and Excel are a 'problem' depends on your perspective. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Word list to Excel
    ... In your original post, you said "I have a long list of words in a Word 2007 file". ... Not sure what the formatting was but there was no crowding or other physical hinderances. ... click on whatever Excel cell you want to use as the starting point and paste the list. ... Only in that case, or by selecting the formula bar, would everything go into one cell. ...
    (microsoft.public.excel)
  • Re: Retaining formats
    ... keep recording as you format your data the way you like ... with the recorded macro. ... So I do File|SaveAs and save the header as an Excel workbook. ... open the file and see that the formatting is retained. ...
    (microsoft.public.excel.misc)