Results 1 to 3 of 3
  1. #1
    Newbie
    Join Date
    February 22nd, 2008
    Posts
    1
    Concatenate Columns to create an email
    I'm trying to create a clickable email column that is automatically populated from two other columns.
    Code currently used to create the email

    =J11&"."&I11&"@domain.com" [J11 is First Name I11 is Lastname]

    The problem I have is when I go to copy the cell or click on it I get =J11&"."&I11&"@domain.com" as the actual value instead of what I see which is first.last@domain.com.
    Google search is proving to be a waste of time.

    any help would be great

  2. #2
    Full Member iolaire's Avatar
    Join Date
    October 3rd, 2006
    Location
    Arlington, VA
    Posts
    229
    Excel's format is
    =Concatenate( text1, text2, ... text_n )

    so you want to change
    =J11&"."&I11&"@domain.com" [J11 is First Name I11 is Lastname]
    to
    =Concatenate( J11, ".", I11, "@domain.com")

  3. #3
    Full Member
    Join Date
    October 22nd, 2006
    Posts
    200
    To create a hyperlink you can use the =hyperlink(link_location,friendly_name) function.

    In your example it would look something like this:

    =HYPERLINK("mailto:"&J11&"."&I11&"@domain.com",J11&"."&I11&"@domain.com")

    rgds

    Bob

  4. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Tables and Columns
    By jwg in forum WebMerge (Fourthworld.com)
    Replies: 1
    Last Post: February 11th, 2005, 03:41 AM
  2. merging columns in excel
    By suzigeek in forum Programming / Datafeeds / Tools
    Replies: 15
    Last Post: July 26th, 2004, 02:59 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •