Pasting into Excel

Discussion in 'Mac Basics and Help' started by lizzyluck, Jul 15, 2011.

  1. lizzyluck macrumors newbie

    Joined:
    Jan 1, 2010
    #1
    Hello all!

    I'm not sure where to put this... but I need a little help if it's possible.

    I'm copying information into an excel spreadsheet with marked columns... Name, address, email, phone number etc.

    Is there anyway to copy the bulk information and have it sort into the correct columns?

    At the moment i'm copying each individual piece of information into each column. It's long and time consuming.

    IS it wishful thinking there may be a more efficient way of doing this

    Thanks for any help guys.
     
  2. GimmeSlack12 macrumors 603

    GimmeSlack12

    Joined:
    Apr 29, 2005
    Location:
    San Francisco
    #2
    What is the source that you are copying from? Usually you can do a right-click>"paste special">Unicode text, and you should get your data put into individual columns. But my example is if your source data is from a webpage with tables.
     
  3. lizzyluck thread starter macrumors newbie

    Joined:
    Jan 1, 2010
    #3
    My source is a webpage without tables... for example:

    Name: Mr x

    Address: 1 Street

    No official tables which I suppose makes things difficult?
     
  4. GGJstudios macrumors Westmere

    GGJstudios

    Joined:
    May 16, 2008
    #4
    Can you post a link? Depending on how it's formatted, there may be a quick way to reformat it for pasting into Excel.
     
  5. lizzyluck, Jul 15, 2011
    Last edited: Jul 15, 2011

    lizzyluck thread starter macrumors newbie

    Joined:
    Jan 1, 2010
  6. GGJstudios macrumors Westmere

    GGJstudios

    Joined:
    May 16, 2008
    #6
    Yep, requires login. You should be able to copy the file and paste it into Word, then find/replace as needed to put tabs between fields and paragraph marks between records. Then you should be able to copy/paste as columns into Excel.
     
  7. lizzyluck thread starter macrumors newbie

    Joined:
    Jan 1, 2010
    #7
    At the risk of sounding stupid... do you think you could elaborate on that process?
     
  8. lizzyluck thread starter macrumors newbie

    Joined:
    Jan 1, 2010
    #8
    When I copy the information into word it puts it in nice tidy columns, and when I paste the columns i need, they stay organised but rather than paste across like I need them to they paste down. Any way to fix/adjust that?
     
  9. GimmeSlack12 macrumors 603

    GimmeSlack12

    Joined:
    Apr 29, 2005
    Location:
    San Francisco
    #9
    Select the text from the webpage and copy. Then go to Word and paste. Then hit ctrl-H and do a Find for Name: and replace with <tab>Name: so that when you hit Replace All you'll end up with a tab spaced in front of the Name: columns. Repeat with all the column categories and then copy/paste into Excel.

    Hope that makes sense.

    EDIT: You might be better off Googling some solutions. Not sure we can help you simply with descriptions.
     
  10. lizzyluck thread starter macrumors newbie

    Joined:
    Jan 1, 2010
    #10
    That does make sense! Ill give it a go. Thank you for your help!
     

Share This Page