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

Question

3 years ago

15

3," ",B3) =CONCATENATE(A3,,B3) =CONCATENATE(A3,"",B3)

1 answer:

Vanyuwa [196] · Answer 1 · 2022-07-06T14:49:48+03:00

Answer:

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

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