EXCEL join two cell one with name to email

Discussion in 'BlackHat Lounge' started by zonecrash, Oct 11, 2009.

  1. zonecrash

    zonecrash BANNED BANNED

    Joined:
    Sep 30, 2009
    Messages:
    72
    Likes Received:
    70
    EXCEL join two cell one with name to email


    B1 has the name

    and

    In C1 I want to complete the cell as an email l



    Example;
    B1 --- williamDavis

    C1 --- join B1 to @yahoo.com - RESULTS of "C1" to be [email protected]


    I have tried in C1

    [email protected]
    [email protected]


    NO luck


    Note;
    I am using openoffice if that matters. Spreadsheet.
     
  2. supermat007

    supermat007 Regular Member

    Joined:
    May 8, 2008
    Messages:
    260
    Likes Received:
    403
    in C1 put

    Code:
    =B1&"@yahoo.com"
     
  3. zonecrash

    zonecrash BANNED BANNED

    Joined:
    Sep 30, 2009
    Messages:
    72
    Likes Received:
    70
    thanks
     
    Last edited: Oct 12, 2009
  4. zonecrash

    zonecrash BANNED BANNED

    Joined:
    Sep 30, 2009
    Messages:
    72
    Likes Received:
    70
    it work ... now I am almost there... I have a few more issus
    It may be foolish for you but i am settting up a imacro for regist-

    My next step would be for posting

    I hope I can pm you something?
     
  5. sdtopensied

    sdtopensied Regular Member

    Joined:
    Sep 1, 2009
    Messages:
    211
    Likes Received:
    113
    Occupation:
    Software Developer
    Location:
    Western Hemisphere
    Try this:

    =concatenate(B1,"@yahoo.com")

    This is an Excel function. Haven't tried it in OpenOffice Spreadsheet.

    -SDT
     
    • Thanks Thanks x 1
  6. 0zero2hero

    0zero2hero Newbie

    Joined:
    Jun 18, 2009
    Messages:
    15
    Likes Received:
    1
    I don't know how to do that with openoffice, in excel you need to type:

    =CONCATENATE(A1,B1)

    hope it helps
     
  7. zonecrash

    zonecrash BANNED BANNED

    Joined:
    Sep 30, 2009
    Messages:
    72
    Likes Received:
    70
    thank you ... thanks you ...

    With the help, I have resolved the issue

    great suggestons
     
  8. S M W

    S M W Junior Member

    Joined:
    May 8, 2009
    Messages:
    135
    Likes Received:
    49
    or an alternate... copy the contents of the cells b1 and c1 (columns), then paste that into notepad ++. you will notice a space between the name and @domain.com. use find and replace to find your space and delete! the output is the same.
     
  9. yousefgreat

    yousefgreat Regular Member

    Joined:
    Nov 14, 2008
    Messages:
    286
    Likes Received:
    180
    I have been doing this for the past couple of months on a daily basis.... Thought that nobody else was doing it tht way until I read ur post..lol