Concatenate Name

Hello,

In B3 I have Last Name
In C3 I have First Name
In D3 I have Middle Name

I have this formula to have full name in E3:

=CONCATENATE(C3&" "&LEFT(D3,1)&"."&" "&B3)

This works fine if there is a middle name but leaves a period in the place of middle name if there isn't one.

How can the formula be altered so I get either:

John Smith
John H. Smith (if there is a middle name)

Thank you,
XJ

Just add an If statement

=IF(D3="",C3&" "&B3,CONCATENATE(C3&" "&LEFT(D3,1)&"."&" "&B3))

Brilliant! Thank you so much.

Thanks for the rep