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))))
<tbody>
</tbody>
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>