View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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
"?