Finally, we concatenated the value in C2 (the last name). We followed this by a dot operator and space. Here, we specified that if cell B2 is not blank (that means if a middle name exists), we want just the first character from the cell B2. The LEFT() function takes the specified number of characters starting from the left side of the text in a cell. If you want to have the first name, followed by the middle name’s initial, followed by the last name, then your formula in D2 can be =CONCATENATE(A2,IF(B2=””,” “,” “&LEFT(B2,1)&”.”),C2). ![]()
0 Comments
Leave a Reply. |