Making email address from name column

[Guest]

Hello,

I'm looking for an easy way to creat email address from name column. Any
suggestion?

Such as, Column A with fisrt name 'John', column B with last name 'Doe', and
wish to create an email address in column C as '(e-mail address removed)'.

Many thanks,

 

[Peo Sjoblom]

=LOWER(A2)&"."&LOWER(B2)&"@abc.com"

copy down


--


Regards,


Peo Sjoblom

 

[Guest]

Hello Peo,

Mnat thanks for the help. I appreciate that. Actully I just realized that my
situation is bit different.

What i have is:
Column A with full name 'John Doe'. I want to make Column B with
"(e-mail address removed)"

If possible what I also like to do is to creat a new column B and populate
with value by taking out the last name 'Doe' from column A. After that I can
use your follwing formula.

 

[Peo Sjoblom]

Make sure column B is empty, if not insert a new column B, then select A and
do data>text to columns, select delimited and click next, select space as
delimiter and click finish

then you can use the formula I gave you

If you want to convert John Doe using a formula in B you can use

=LOWER(SUBSTITUTE(A2," ","."))&"@abc.com"


--


Regards,


Peo Sjoblom

 

[Guest]

Excellent!!

It worked! Many thanks

Make sure column B is empty, if not insert a new column B, then select A and
do data>text to columns, select delimited and click next, select space as
delimiter and click finish

then you can use the formula I gave you

If you want to convert John Doe using a formula in B you can use

=LOWER(SUBSTITUTE(A2," ","."))&"@abc.com"


--


Regards,


Peo Sjoblom