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

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 williamdavis@yahoo.com


    I have tried in C1

    =B1@yahoo.com
    =B1+@yahoo.com


    NO luck


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

    supermat007 Regular Member

    Joined:
    May 8, 2008
    Messages:
    261
    Likes Received:
    401
    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:
    282
    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