Formula/Concatenate to ignore a cell if value is blank

[karimel_romeo]

Hi Guys,

I have a table with First Name, Middle Name, and Last Name. I have another cell that concatenates these results and includes "," so that the results appear as such: John, Smith, M. This works fine until someone does not have a middle name and the following result is displayed: John, Smith, - In this instance I need the last "," after "Smith" to not be there. Any ideas of how to do this?

I attach an example that shows how I have it set up. By all means, feel free to tell me any better ways to do this.

Thanks,