Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to convert to email address?
Given a column of cells each with text in the format:
LAST NAME, FIRST NAME ..... like "Jones, Bob" and "Johnson, David", is there a quick excel function/method that will convert and then write them to a different column such that: (first initial)(last .... so "Jones, Bob" becomes " and "Johnson, David" becomes "? TIA |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to convert to email address?
Charlie
Technically you may need this =HYPERLINK("mailto:"&LOWER((MID(A1,FIND(",",A1,1)+ ",LOWER((MID(A1,FIND(",",A1,1)+2,1))& ") You could drop the lower if the case is not important and the repeating part if you can put up with rather than -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk UK Excel User Conference In Cambridge November 28th - December 1st 2007 Register Now @ http://www.exceluserconference.com/UKEUC.html wrote in message oups.com... Given a column of cells each with text in the format: LAST NAME, FIRST NAME .... like "Jones, Bob" and "Johnson, David", is there a quick excel function/method that will convert and then write them to a different column such that: (first initial)(last ... so "Jones, Bob" becomes " and "Johnson, David" becomes "? TIA |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to convert to email address?
=MID(A1,FIND(" ",A1)+1,1)&LEFT(A1,FIND(" "
I don't know how to get rid of the underlines, sorry! -- Kind regards, Niek Otten Microsoft MVP - Excel wrote in message oups.com... | Given a column of cells each with text in the format: | | LAST NAME, FIRST NAME | | .... like "Jones, Bob" and "Johnson, David", is there a quick excel | function/method that will convert and then write them to a different | column such that: | | (first initial)(last | | ... so "Jones, Bob" becomes " and "Johnson, David" | becomes "? | | TIA | |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to convert to email address?
On Nov 12, 12:26 pm, "Nick Hodge" wrote:
Charlie Technically you may need this =HYPERLINK("mailto:"&LOWER((MID(A1,FIND(",",A1,1)+ ",LOWER((MID(A1,FIND(",",A1,1)+2,1))& ") You could drop the lower if the case is not important and the repeating part if you can put up with rather than -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England web:www.nickhodge.co.uk UK Excel User Conference In Cambridge November 28th - December 1st 2007 Register Now @http://www.exceluserconference.com/UKEUC.html wrote in message oups.com... Given a column of cells each with text in the format: LAST NAME, FIRST NAME .... like "Jones, Bob" and "Johnson, David", is there a quick excel function/method that will convert and then write them to a different column such that: (first initial)(last ... so "Jones, Bob" becomes " and "Johnson, David" becomes "? TIA Awesome, awesome, awesome. Thank you very much, it works like a charm. -CW |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function to convert to email address?
Charlie
Glad it worked. -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk UK Excel User Conference In Cambridge November 28th - December 1st 2007 Register Now @ http://www.exceluserconference.com/UKEUC.html wrote in message ups.com... On Nov 12, 12:26 pm, "Nick Hodge" wrote: Charlie Technically you may need this =HYPERLINK("mailto:"&LOWER((MID(A1,FIND(",",A1,1)+ ",LOWER((MID(A1,FIND(",",A1,1)+2,1))& ") You could drop the lower if the case is not important and the repeating part if you can put up with rather than -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England web:www.nickhodge.co.uk UK Excel User Conference In Cambridge November 28th - December 1st 2007 Register Now @http://www.exceluserconference.com/UKEUC.html wrote in message oups.com... Given a column of cells each with text in the format: LAST NAME, FIRST NAME .... like "Jones, Bob" and "Johnson, David", is there a quick excel function/method that will convert and then write them to a different column such that: (first initial)(last ... so "Jones, Bob" becomes " and "Johnson, David" becomes "? TIA Awesome, awesome, awesome. Thank you very much, it works like a charm. -CW |
Reply |
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 |