Results 1 to 3 of 3
  1. #1
    Join Date
    February 22nd, 2008
    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&"" [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&"" as the actual value instead of what I see which is
    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
    Arlington, VA
    Excel's format is
    =Concatenate( text1, text2, ... text_n )

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

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

    In your example it would look something like this:




  4. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Tables and Columns
    By jwg in forum WebMerge (
    Replies: 1
    Last Post: February 11th, 2005, 02:41 AM
  2. merging columns in excel
    By suzigeek in forum Programming / Datafeeds / Tools
    Replies: 15
    Last Post: July 26th, 2004, 01: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