How do I combine the first character of a cell with another cell in Excel? December 19, 2023 by Tarik =CONCATENATE(LEFT(A1,1), B1) Assuming A1 holds 1st names; B1 Last names