Can this be done in Excel?

Discussion in 'General Chat' started by shylesson, Jun 6, 2007.

  1. #1
    I have a large list of names and a short list of email extensions. Is there a way to resolve each name to each extension? In other words this is what I have:

    name1 @corporatebank.com, @unitedbank.com, @capitalworldwide.com
    name2
    name3
    name4
    name5
    name6
    name7
    name8
    name9
    name10
    name11
    name12
    name13

    And need it to be:








    etc... Anything that will prevent me from having to type the name and extension over and over again as I have a long list of clients that I have to do this with. Or am I just stuck like chuck? Or is there another program I can do this in?
     
    shylesson, Jun 6, 2007 IP
  2. hugodiaz

    hugodiaz Well-Known Member

    Messages:
    971
    Likes Received:
    28
    Best Answers:
    0
    Trophy Points:
    120
    #2
    I'm confident that can be done using macros,(In Excel) but I'm too rusty to say exactly how. Maybe try asking in another section of the board and you might get some help. I think a good place is in the 'Buy Sell and Trade' board.

    Good luck.
     
    hugodiaz, Jun 6, 2007 IP
  3. seospider

    seospider Peon

    Messages:
    368
    Likes Received:
    39
    Best Answers:
    0
    Trophy Points:
    0
    #3
    is quite simple to do it.

    hey is best if you try it in access instead.

    Well I can also do it for you if you could offer me something out of your own interest :p
     
    seospider, Jun 7, 2007 IP
  4. sachin410

    sachin410 Illustrious Member

    Messages:
    6,422
    Likes Received:
    573
    Best Answers:
    0
    Trophy Points:
    410
    #4
    If email extensions are common to all names, then it is pretty simple.

    Send me a sample and I will send you the instructions of how exactly to achieve this.
     
    sachin410, Jun 7, 2007 IP
  5. rmsiu

    rmsiu Banned

    Messages:
    59
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    I believe is easier with php
    try google it
     
    rmsiu, Jun 7, 2007 IP
  6. freespace

    freespace Well-Known Member

    Messages:
    718
    Likes Received:
    15
    Best Answers:
    1
    Trophy Points:
    140
    #6
    There is a tool that can do this easily.

    "The permutator"

    Basically a keyword tool that allows you to make combinations of keyword phrases from different keywords.

    For you it would be names and domains instead of keywords.

    There is another free one called good keywords - i haven't tried this tho.

    Its also easy to do in excel as well. All you need is to concatenate the name with the domain.
     
    freespace, Jun 7, 2007 IP