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