Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Copying bit of table to Excel

  • 20-12-2007 8:20pm
    #1
    **Timbuk2**
    Moderators, Education Moderators, Motoring & Transport Moderators Posts: 7,396 Mod ✭✭✭✭


    Hi everyone

    Is it possible to copy a specific column of a table to excel. I want it so that every entry would be in the cell under the preceding entry

    For example, http://www.timeanddate.com/worldclock/astronomy.html?n=78&month=1&year=2008&obj=sun&afl=-11&day=1

    I want the Sunset time to be in a vertical column down like it is on the page, only in Excel 2007. Is there any easy way of doing this, or do I have to copy all the info in?

    Thanks in advance,
    Tim


Comments

  • #2
    Plascebo
    Registered Users, Registered Users 2 Posts: 798 ✭✭✭Plascebo


    Hi Timbuk2,

    Have looked at the document, the only way I could get what you required was to copy all the data to an excel sheet, then, holding the ctrl button click on the A, B, D, E etc columns (i.e. the columns you don't want) and right click and delete.

    Hope this is of some help


  • #3
    **Timbuk2**
    Moderators, Education Moderators, Motoring & Transport Moderators Posts: 7,396 Mod ✭✭✭✭**Timbuk2**


    When I do that the whole document just pastes as one whole continuous line

    e.g 1 Jan 200808:4116:167h 35m 04s+ 1m 08s12:2813.6° 147.0962 Jan 20080

    It doesn't paste right with the formatting!


  • #4
    Capt'n Midnight
    Moderators, Recreation & Hobbies Moderators, Science, Health & Environment Moderators, Technology & Internet Moderators Posts: 93,604 Mod ✭✭✭✭Capt'n Midnight


    not really
    easiest way is to copy the lot and then hid the columns you don't want that way when you paste again the ones you don't want to see stay hidden


  • #5
    **Timbuk2**
    Moderators, Education Moderators, Motoring & Transport Moderators Posts: 7,396 Mod ✭✭✭✭**Timbuk2**


    Hi I figured it out. I will post the method for those that want to know

    I went to the data tab. Then I pressed on "From Web". Entered the URL, and it showed the website. For every table on the webpage, it showed a yellow arrow beside it. Just press on the yellow arrow to import it in (formatted correctly and all)

    Excel 2007 is very handy


Advertisement