I have a worksheet that contains the following columns.

First Name, Last Name, Web Address
David, Aardsma, http://wm.com

I am looking for the capability to auto populate an email adress as:



Is there a function that can pull the first name, last name and then just
the text after the http://?

Thanks in advance!

Sean