In cell C8 on the "Summer Bookings" worksheet, insert a function that joins the customer "Lastname" to the customer "Firstname" separated by a comma and space. (Example: Campbell, David).

1. In cell C8 on the "Summer Bookings" worksheet, insert the following CONCAT function: "=CONCAT(E6, ", ",D6)" OR "=E6&", "&D6".

Perform operations with formulas and functions

Question

In cell C8 on the "Summer Bookings" worksheet, insert a function that joins the customer "Lastname" to the customer "Firstname" separated by a comma and space. (Example: Campbell, David).

Explanation

In cell C8 on the "Summer Bookings" worksheet, insert the following CONCAT function: "=CONCAT(E6, ", ",D6)" OR "=E6&", "&D6".

Topics

#CONCAT#text functions#string joining#TEXTJOIN

Community Discussion

No community discussion yet for this question.

Full 77-727 Practice