Pasting into Excel

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

Most Liked Posts
  1. lizzyluck, Jul 15, 2011

    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.
     
    share
    + Quote Reply
  2. GimmeSlack12, Jul 15, 2011

    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.
     
    share
    + Quote Reply
  3. lizzyluck, Jul 15, 2011

    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?
     
    share
    + Quote Reply
  4. GGJstudios, Jul 15, 2011

    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.
     
    share
    + Quote Reply
  5. lizzyluck, Jul 15, 2011
    Last edited: Jul 15, 2011

    lizzyluck thread starter macrumors newbie

    Joined:
    Jan 1, 2010
    #5
    but here is the
     
    share
    + Quote Reply
  6. GGJstudios, Jul 15, 2011

    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.
     
    share
    + Quote Reply
  7. lizzyluck, Jul 15, 2011

    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?
     
    share
    + Quote Reply
  8. lizzyluck, Jul 15, 2011

    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?
     
    share
    + Quote Reply
  9. GimmeSlack12, Jul 15, 2011

    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.
     
    share
    + Quote Reply
  10. lizzyluck, Jul 15, 2011

    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
    + Quote Reply
(You must log in or sign up to post here.)

Share This Page