155k views
1 vote
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&" "C2 A2&" "&B2&" "C2 =CONCATENATE(A2&" "&B2&" "C2) =CONCATENATE(A2," ",B2," "C2) =CONCATENATE(A2)&" "&(B2)&" "(C2)

User Xbadal
by
7.3k points

1 Answer

4 votes

Answer:

A. =A2&“ ”&B2&“ ”C2

D. =CONCAT (A2,“ ”,B2,“ ”C2)

User PointXIV
by
7.4k points