create email addresses with a _ from excel

April 28, 2011 at 21:28:51
Specs: Windows XP
Hello

I have extracted a large amount of data from Visio and have to compile email addresses from the data. One column has first names another column has the surname.

The company email addresses are in this format

firstname_surname@company.com

All the formulas that I use advise that there is an error regarding the "_"

Is anyone able to help with this?

Thanks


See More: create email addresses with a _ from excel

Report •


#1
April 28, 2011 at 23:49:30
re: ...there is an error regarding the "_"...

What error?

With this data...

          A           B             C
1       First        Last        Company

I used:

=A1 & "_" & B1 & "@" & C1 & ".com"

which returned:

First_Last@Company.com

Edit...PasteSpecial...Value...Double-Click turned it into a click-able email address hyperlink which opens my email app.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
May 8, 2011 at 17:59:07
Thanks for this - it worked fine!

Report •

#3
May 26, 2011 at 20:24:42
This works really well but some of the staff members have a space in their surname or have two surnames.

i.e. Johnson Smith

How do I use this formula to remove any spaces in their first or surname.

Thanks


Report •

Related Solutions

#4
May 27, 2011 at 02:31:33
This formula will eliminate any spaces in A1 and B1:

=SUBSTITUTE(A1," ","") & "_" & SUBSTITUTE(B1," ","") & "@" & C1 & ".com"

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#5
May 29, 2011 at 17:18:49
Great - thanks again for your help!!!

Report •

Ask Question