Which formula correctly uses CONCAT to join B2 and C2 with a colon between, producing Rent:Parking?

Which formula correctly uses CONCAT to join B2 and C2 with a colon between, producing Rent:Parking?

• A. =CONCAT(B2, ":", C2)
• B. =CONCAT(B2, " - ", C2)
• C. =TEXTJOIN("", TRUE, B2, C2)
• D. =B2 & ":" & C2

Answer: (A)

CONCAT combines text items in the order you provide them. To put a colon between the two cell values, include the colon as its own text item: =CONCAT(B2, ":", C2). If B2 contains Rent and C2 contains Parking, this yields Rent:Parking. The other options don’t fit the requirement: they either use a different separator, omit the separator, or don’t use CONCAT at all (even though an ampersand could produce the same result, it doesn’t meet the “using CONCAT” condition).

CONCAT combines text items in the order you provide them. To put a colon between the two cell values, include the colon as its own text item: =CONCAT(B2, ":", C2). If B2 contains Rent and C2 contains Parking, this yields Rent:Parking. The other options don’t fit the requirement: they either use a different separator, omit the separator, or don’t use CONCAT at all (even though an ampersand could produce the same result, it doesn’t meet the “using CONCAT” condition).