Concatenation of text can be done using

A. Apostrophe ( ‘ )

B. Exclamation ( ! )

C. Hash ( # )

D. Ampersand ( & )

Answer: Option D

Solution(By Examveda Team)

The ampersand (&) calculation operator allow us join text items without using a function. For example, =A1 & B1 will return the same value as =CONCATENATE(A1,B1). In many cases, using the ampersand operator is quicker and simpler than using CONCATENATE to create strings.

Join The Discussion

Related Questions on MS Excel