Concatenation Question

[reberryjr]

I have what should be a simple task. I'm trying to concatenate some cells to complete a name. I didn't have an issue before I added the middle initial to the formula, but now I'm struggling. I've searched the forum, but only see concatenation examples for First and Last names, not anything with 4 parameters that accounts for missing data (MI and/or Suffix).

The basic layout is below, with expected results. Here's the formula that I'm using, that is not working:

=IF(G3="",IF(E3="",D3&" "&F3,IF(G3="",D3&" "&E3&" "&F3,IF(E3="",D3&" "&F3&" "&G3,D3&" "&E3&" "&F3&" "&G3))))

Column D	Column E	Column F	Column G	Column H
First	MI	Last	Suffix	Name
Tommy	J.	Boy	Sr.	Tommy J. Boy Sr.
Tommy		Boy	Sr.	Tommy Boy Sr.
Tommy	J.	Boy		Tommy J. Boy
Tommy		Boy		Tommy Boy

<tbody>
</tbody>

 

[reberryjr]

Understood.