Joins several text strings into one text string and up to 30 strings can be joined using syntax below.
&can also be used as calculation operator instead of the
CONCATENATEfunction to join text items.
As shown below, we can get full name by concatenating last name, first name and middle name. I also used
ISBLANK()function so that we can get nice results for blank or empty middle name.
Formula Example 1
Formula Example 2
=CONCATENATE(B3,", ",A3," ",LEFT(C3,1),IF(ISBLANK(C3),"","."))
Double click cells under Full Name(Column D) to see actual formula used.
=B12&", "&A12&" "&IF(ISBLANK(C12),"",LEFT(C12,1)&".")