1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

I have a list of 100 dentists by name and email address but need help combining them!

Discussion in 'Offline Marketing' started by truelux, Aug 1, 2012.

  1. truelux

    truelux Regular Member

    Joined:
    Jun 16, 2011
    Messages:
    298
    Likes Received:
    91
    Not sure of the best way to do this but I have a list of 100 dentists in an excel file.

    | NAME | EMAIL |

    How can I combine both columns so that it goes into name <email> form so I can send an email out to them? I also know that by sending multiple emails, I have to include a comma between each account? so how can I do that as well?

    I don't want to manually add all of the <>,

    thanks! :p
     
  2. lurnme

    lurnme Regular Member

    Joined:
    Jul 16, 2008
    Messages:
    309
    Likes Received:
    94
    Quick way I would prob do to save time thinking of better way would be to:

    Export to text file

    Import back into excel with column divided by |
    Once its broken into columns delete all |'s
    Add a column in between the name and email
    type < in the first row then highlight that cell and double the little square on the bottom, it will fill all the way down.
    Then in column after the email put >, highlight-doubleclick to fill.

    Save to text file

    Open file in notepad++

    CTRL-F to open find

    Choose extended in the search mode
    Find what: \r\n
    Replace with: leave blank
    Click Replace All

    You could also just use notepad++ to do the whole process if you know how to use reg ex by using search mode-regular expression
     
    • Thanks Thanks x 1
  3. truelux

    truelux Regular Member

    Joined:
    Jun 16, 2011
    Messages:
    298
    Likes Received:
    91
    notepad++ really helped with the find and replace all functionality!
     
  4. lurnme

    lurnme Regular Member

    Joined:
    Jul 16, 2008
    Messages:
    309
    Likes Received:
    94
    Yes make notepad++ your default txt editor, get rid of notepad.

    Here is a quick way to do it with just notepad++ if your not too familiar with regex

    Search Mode - Regex

    1) Remove the first |

    Find what: ^|
    Replace with: leave blank
    Replace All

    2) Replace the last | with >,
    Find what: |$
    Replace with: >,
    Replace All

    3) Replace the middle |
    Find what: |
    Replace with: <
    Replace All

    4) Remove line breaks - would be huge line though
    Set search mode to Extended
    Find what: \r\n
    Replace with: leave blank
    Repalce All