Making email address from name column
 

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

Many thanks,

Making email address from name column
 

"

copy down


--


Regards,


Peo Sjoblom


"Moin" wrote in message
...
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 '.

Many thanks,

Making email address from name column
 

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
"

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" wrote:

"

copy down


--


Regards,


Peo Sjoblom


"Moin" wrote in message
...
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 '.

Many thanks,

Making email address from name column
 

Make sure column B is empty, if not insert a new column B, then select A and
do datatext 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," "


--


Regards,


Peo Sjoblom




"Moin" wrote in message
...
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
"

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" wrote:

"

copy down


--


Regards,


Peo Sjoblom


"Moin" wrote in message
...
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 '.

Many thanks,

Making email address from name column
 

Excellent!!

It worked! Many thanks

"Peo Sjoblom" wrote:

Make sure column B is empty, if not insert a new column B, then select A and
do datatext 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," "


--


Regards,


Peo Sjoblom




"Moin" wrote in message
...
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
"

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" wrote:

"

copy down


--


Regards,


Peo Sjoblom


"Moin" wrote in message
...
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 '.

Many thanks,