| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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, |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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, |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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, |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort a column of email addresses by end portion of address | Excel Discussion (Misc queries) | |||
| can I copy a column of email addresses, paste into email address? | New Users to Excel | |||
| How to extract email address and place into a new column | Excel Worksheet Functions | |||
| stop automatically making email address | Excel Discussion (Misc queries) | |||
| How do you add a parentesis to a column of email address? | Excel Discussion (Misc queries) | |||
Linear Mode
