Question

which of the following ia a text concatenation operator in ms Excel​

Answer 1

⠀⠀ ⠀ ⠀⠀ $\huge{\tt{\red{❥}\green{A}\purple{N}\pink{S}\blue{W}\orange{E}\red{R}}}$The ampersand (&) calculation operator lets you join text items without having to use a function. For example, =A1 & B1 returns the same value as =CONCATENATE(A1,B1)....