Pasting into Excel

lizzyluck

macrumors newbie
Original poster
Jan 1, 2010
13
0
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.
 

GimmeSlack12

macrumors 603
Apr 29, 2005
5,395
8
San Francisco
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.
 

lizzyluck

macrumors newbie
Original poster
Jan 1, 2010
13
0
My source is a webpage without tables... for example:

Name: Mr x

Address: 1 Street

No official tables which I suppose makes things difficult?
 

GGJstudios

macrumors Westmere
May 16, 2008
44,427
762
I'm not sure it'll allow you to see it as you need a login.
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.
 

lizzyluck

macrumors newbie
Original poster
Jan 1, 2010
13
0
At the risk of sounding stupid... do you think you could elaborate on that process?
 

lizzyluck

macrumors newbie
Original poster
Jan 1, 2010
13
0
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?
 

GimmeSlack12

macrumors 603
Apr 29, 2005
5,395
8
San Francisco
At the risk of sounding stupid... do you think you could elaborate on that process?
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.
 

Similar threads

Register on MacRumors! This sidebar will go away, and you'll see fewer ads.