Can Excel do this?

JoeMcVoy · Apr 4th, 2002, 01:26 PM

I tried to cut and paste a list of numbers and names from a Overture search (under placing an ad and doing it yourself, they have a tool that tells you how many searches they had the prior month on that and related terms) When I cut and paste into Excel 97 it looks weird - each line takes up more than one row, links are hyperlinks, etc Excel will not add up the numbers in the column either. What I want to do is get the list into 2 columns so I can sort, add up, etc. Can this be done ir is the format I copied from Overture make it impossible?

Thanks!

Joe

Tim Francis-Wright · Apr 4th, 2002, 01:53 PM

Instead of pasting into excel, use the Paste Special command and select Text as the
format. This will put the number of hits and the search term all into one cell.

To get the number and the search terms into different cells, use Data/Text to Columns.

HTH

dk · Apr 4th, 2002, 02:09 PM

Tim Francis-Wright! Where have you been my friend? You answered some tricky questions for me a long time ago on the old board. It's good to see your name again.

Regards,

A friend, Dan - who was known as something else on the old board but I'm now using my own tag.

Jack in the UK · Apr 4th, 2002, 04:46 PM

dk Dan -- keep going stranger, mums the word!

back in the day i used to drink in the tankard! and others the chaplin... and use to post anno.. as i felt back some 18 months no one was intrest in what i had to say...

Apr 4th, 2002, 01:53 PM	#2
Tim Francis-Wright Board Regular Join Date: Feb 2002 Posts: 74	Instead of pasting into excel, use the Paste Special command and select Text as the format. This will put the number of hits and the search term all into one cell. To get the number and the search terms into different cells, use Data/Text to Columns. HTH __________________ "Interfere? Of course we should interfere! Always do what you're best at, that's what I say!" -- The Doctor, Nightmare of Eden

Apr 4th, 2002, 04:46 PM	#4
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	dk Dan -- keep going stranger, mums the word! back in the day i used to drink in the tankard! and others the chaplin... and use to post anno.. as i felt back some 18 months no one was intrest in what i had to say... __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 4th, 2002, 01:26 PM	#1
JoeMcVoy New Member Join Date: Apr 2002 Location: Promotional Products Consulting Posts: 1	I tried to cut and paste a list of numbers and names from a Overture search (under placing an ad and doing it yourself, they have a tool that tells you how many searches they had the prior month on that and related terms) When I cut and paste into Excel 97 it looks weird - each line takes up more than one row, links are hyperlinks, etc Excel will not add up the numbers in the column either. What I want to do is get the list into 2 columns so I can sort, add up, etc. Can this be done ir is the format I copied from Overture make it impossible? Thanks! Joe

Apr 4th, 2002, 02:09 PM	#3
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	Tim Francis-Wright! Where have you been my friend? You answered some tricky questions for me a long time ago on the old board. It's good to see your name again. Regards, A friend, Dan - who was known as something else on the old board but I'm now using my own tag.