Extract & Arrange emails from excel databse

Discussion in 'MySQL' started by vishal_gupta, Sep 19, 2010.

  1. #1
    I have extracted users table my VB forum database and exported it to MS EXCEL. Now, I want to get emails as a list in this format
    "Contact Person Name"<mail address>,"Contact Person Name"<mail address>

    Actually I have tow columns User name and email address and I want to get data from "user name" column to "Contact Person Name" and from "email address" column to Mail addresses.

    I have read a thread on another forum and it has helped me lot but this gives list as
    mail address,mail address but i need the list in this fashion "Contact Person Name"<mail address>.
    I think this can be done with excel formulas. Can any one help me??
     
    vishal_gupta, Sep 19, 2010 IP
  2. vishal_gupta

    vishal_gupta Well-Known Member

    Messages:
    161
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    113
    #2
    No one is willing to answer me.
     
    vishal_gupta, Sep 21, 2010 IP