I am trying to use a combination of Concatenate and IF formula to produce an email.
My input.
D4: First Name:
D5: Middle Name:
D6: Last Name:
D8: Organization:
Once all these are filled, I want the formula to produce a result like
[email protected]
I have used the following formula.
Problem is if there is a middle name the formula works fine, but in case where there is no middle name, it produces the following result.
[email protected]
Please advice how do I remove the additional (.) in cases where there is no middle name.
Bookmarks