Question

What formula would you enter in C3 that combines A3 and B3 to get a result like in C2? =CONCATENATE("A3","","B3") =CONCATENATE(A3," ",B3) =CONCATENATE(A3,,B3) =CONCATENATE(A3,"",B3)

Answer 1

Option B, =CONCATENATE(A3," ",B3)

Step-by-step explanation:

CONCATENATE function is used to join two or more strings together. The syntax for CONCATENATE function in Microsoft Excel is:

CONCATENATE( text1, [ text2, ... text_n ] )

Where, ext1, text2, ... text_n represents the strings that are to be joined together.

CONCATENATE(A2," ",B2)

The above syntax is used when space is to be entered between two string values

Hence, option B is correct