Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

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.
 
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.
 
My source is a webpage without tables... for example:

Name: Mr x

Address: 1 Street

No official tables which I suppose makes things difficult?
 
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.
 
At the risk of sounding stupid... do you think you could elaborate on that process?
 
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?
 
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.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.