Which formulas would work to combine cells with first, middle, and last names from columns A through C and row 2 into a new cell? Check all that apply.=A2&“ ”&B2&“ ”C2A2&“ ”&B2&“ ”C2=CONCAT(A2&“ ”&B2&“ ”C2)=CONCAT(A2,“ ”,B2,“ ”C2)=CONCAT(A2)&“ ”&(B2)&“ ”(C2)

Question

Revolt · Accepted Answer

=A2&“ ”&B2&“ ”C2; =CONCAT(A2,“ ”,B2,“ ”C2)

Working with Functions

Which formulas would work to combine cells with first, middle, and last names from columns A through C and row 2 into a new cell? Check all that apply.=A2&“ ”&B2&“ ”C2A2&“ ”&B2&“ ”C2=CONCAT(A2&“ ”&B2&“ ”C2)=CONCAT(A2,“ ”,B2,“ ”C2)=CONCAT(A2)&“ ”&(B2)&“ ”(C2)

More from this Course