software

I have four feilds, First, Middle, Last and Email. I want to use a
concatenation function in Email to combine First middle and last and
automatically add the @aol.com. My formula is as follows:
quot;)

The problem is when the user does not have a middle initial, my company
merely skips it. How do I prevent the double quot;..quot; when the middle inital is
not present?

In my example below, John's email address is perfect. However, Mary's has
the double dot (..) between her first and last.

FirstName MI LastName EmailAddress
John B Doe
Mary Smith

Any help is greatly appreciated.

Thanks,

Cindi

One way: =CONCATENATE(A2,quot;.quot;,B2,IF(B2=quot;quot;,quot;quot;,quot;.quot;),C2,quot;@anywh ere.comquot;)
--Bruce

quot;~Cquot; wrote:

gt; I have four feilds, First, Middle, Last and Email. I want to use a
gt; concatenation function in Email to combine First middle and last and
gt; automatically add the @aol.com. My formula is as follows:
gt; quot;)
gt;
gt; The problem is when the user does not have a middle initial, my company
gt; merely skips it. How do I prevent the double quot;..quot; when the middle inital is
gt; not present?
gt;
gt; In my example below, John's email address is perfect. However, Mary's has
gt; the double dot (..) between her first and last.
gt;
gt; FirstName MI LastName EmailAddress
gt; John B Doe
gt; Mary Smith
gt;
gt; Any help is greatly appreciated.
gt;
gt; Thanks,
gt;
gt; Cindi