You are the owner of a small bicycle tour company summarizing trail rides that have been booked for the next six months.
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).
Answer is in the explanation below.
Reference / correct answer:
See explanation below.
1. In cell C8 on the “Summer Bookings” worksheet, insert the following CONCAT function: “=CONCAT(E6 “, “D6)” OR “=E6& “, “, D6”.