Posted to microsoft.public.excel.worksheet.functions
|
|
converting email address formats
Try
=LOWER(LEFT(A1,1) & "),
FIND(".",A1)+1,255))
If this post helps click Yes
---------------
Jacob Skaria
"rlpetrie12" wrote:
How do I write a macro to convert one email format to another. i.e.,
to (the first and last names are
capitalized and need to be first letter of first name combined with last
name, all lowercase and change the multiple email providers and extensions to
"?
|