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
Bookmarks