Making email address from name column

M

Moin

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,
 
M

Moin

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.
 
P

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
 
M

Moin

Excellent!!

It worked! Many thanks

Peo Sjoblom said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top