The imported contact name data separates the first and last names, but Darius wants to list the full name in one cell. List the first and last names of each contact in a single cell using worksheet references as follows: In cell J6, enter a formula using the CONCAT function that displays the first name shown in cell C3 of the New Clients worksheet followed by a space (" "), and then the last name shown in cell D3 of the New Clients worksheet.