Concatenation question

[~C]

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:
=CONCATENATE(A2,".",B2,".",C2,"@anywhere.com")

The problem is when the user does not have a middle initial, my company
merely skips it. How do I prevent the double ".." 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 (e-mail address removed)
Mary Smith (e-mail address removed)

Any help is greatly appreciated.

Thanks,

Cindi

 

[bpeltzer]

One way: =CONCATENATE(A2,".",B2,IF(B2="","","."),C2,"@anywhere.com")
--Bruce