| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formulate email address based on last name & first letter of first
I need to formulate an email address for hundreds of employees. The email
address is the first 7 letters of the name and first letter of first name followed by @....com Is there a formula that will take the last name column (only up to the first 7 letters), the first letter of the first name column and add the @.....com to the end? Any help would be greatly appreciated! Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| send wkbk as an email attachment with an email address copied from | Excel Discussion (Misc queries) | |||
| how can i convert an email address to a web address | Excel Worksheet Functions | |||
| can I copy a column of email addresses, paste into email address? | New Users to Excel | |||
| Transfer Email addresses from spreadsheet to email address book | Excel Discussion (Misc queries) | |||
| Shut off email address from linking to email program? | Excel Worksheet Functions | |||
Threaded Mode
