Results 1 to 3 of 3

Thread: Converting text to an email address hyperlink

  1. #1
    Junior Member Aerodynamix's Avatar
    Join Date
    Jul 2013
    Posts
    2
    Rep Power
    0

    [SOLVED] Converting text to an email address hyperlink

    I am trying to take a name in a cell & convert it into an email address hyperlink (example attached)
    The steps I have taken so far are:

    1) In cell A1 of the attached example sheet the name appears with a space between the firstname & lastname.

    2) In cell B1 I am using the SUBSTITUTE formula to remove the space between the first name & lastname and replace it with a period (.).

    3) In cell C1 I am taking the contents from cell B1 & adding "@xyz.com" to the end of it

    4) I then try to show the contents of C1 in D1 but what I am actually seeing is John.Doe@xyz.com in the cell itself but the formula bar is displaying "=C1" making it useless to me.

    I wouldn't be the slightest bit surprised if there is a far easier way of achieving this and any help is greatly appreciated

    Example.xlsx
    Last edited by Aerodynamix; 08-09-2013 at 07:20 PM.

  2. #2
    Junior Member Aerodynamix's Avatar
    Join Date
    Jul 2013
    Posts
    2
    Rep Power
    0
    I think I've solved this one. It's always the way... as soon as you post asking for help, the answer appears as if by magic.

    It seems that using the HYPERLINK/Mailto function works perfectly.

    Example2.xlsx

  3. #3
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Thanks for sharing the solution !
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

Similar Threads

  1. VBA To Extract Email Address From Text
    By dunndealpr in forum Excel Help
    Replies: 43
    Last Post: 06-05-2019, 03:56 PM
  2. Replies: 2
    Last Post: 07-04-2013, 12:37 PM
  3. VBA Code to email using Globals Address Book
    By cdurfey in forum Excel Help
    Replies: 5
    Last Post: 05-28-2013, 10:25 PM
  4. Replies: 2
    Last Post: 05-23-2013, 08:08 AM
  5. Converting text strings to points
    By Rasm in forum Excel Help
    Replies: 1
    Last Post: 10-23-2011, 08:23 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
  •