Formula to combine cells to build email address

[yitbos]

Hello everyone. I've got an interesting question for you.

I have a worksheet with three columns. First Name, Last Name and email address. I need to combine the first name with the last name and add our @ourcompany.com to the end of it for the emaill address.

I've figured out how to do that, but my problem is, we don't use our first and last names in the email address. We use first initial and last name.

I know how to make Tom Jones become [email protected]

What I need to know is how to make Tom Jones become [email protected].

Can someone point me in the right direction here? I just need the first initial of the first name and combine that with the last name and then add in the @ourcompany.com.

Thanks for the help. I appreciate it.

John

[VBA Noob]

Maybe

=LEFT(A1,1)&B1&C1

VBA Noob

[Ron Coderre]

With
A1: (a first name....eg Tom)
B1: (a last name....eg Jones)

This formula creates an email address using the first initial and last name

Please Login or Register  to view this content.

In that example, C1 returns: [email protected]

Does that help?

[yitbos]

Your suggestions did work and I've got the list completed. Thank you both very much.

John

[lorika]

This formula works...and you have made my day!