Can Excel do this?
Can Excel do this?
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Can Excel do this?

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Promotional Products Consulting
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    75
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    2,936
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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"

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com