Formula to convert name fields into email addresses in 2007

Hi Experts

How would you write a formula to convert peoples names from col A into email address with a fixed @bbb.com in col B (all names have a space between first and last name in col a)

Col A             Col B
P Keilah        P.keilah@bbb.com

thanks
route217Asked:
Who is Participating?
 
jimyXConnect With a Mentor Commented:
Use this in column B:
=SUBSTITUTE(A1," ",".")&"@bbb.com"
0
 
Pratima PharandeCommented:
write formula in colb like

=CONCATENATE(A1;"@bbb.com")
0
 
MINDSUPERBConnect With a Mentor Commented:
Use this formula:

=LEFT(A1,1)&"."&RIGHT(A1,LEN(A1)-2)&"@bbb.com"

Sincerely,
Ed
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Pratima PharandeConnect With a Mentor Commented:
try this

=CONCATENATE(REPLACE(A1;SEARCH(" ";A1);1;".");"@bbb.com")
0
 
route217Author Commented:
many Thanks for the feedback...
0
 
Rikin ShahConnect With a Mentor Microsoft Dynamics CRM ConsultantCommented:
Try this..

=CONCATENATE(SUBSTITUTE(A1," ","."),"@bbb.com")
0
 
rowanscottCommented:
Hi

I would advise going a step further and use the trim function to remove extraneous spaces in the names.

=SUBSTITUTE(TRIM(A1)," ",".") & "@bbb.com"

Depending on the source of the data it is quite possible you have some extra spaces in there somewhere.

Best regards

Rowan
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.