“&”
Used for –
“&” Function in MS Excel is used for combining two or more values/text/alphanumeric of two cell
to make it as single.
Syntax –
“&” is syntax in itself i.e. no syntax is used for it.
Example – Suppose
you have written 1in cell A1 and 2 in cell A2 and you want 12 result by
combining cell A1 and Cell A2 in cell A3 then just type A1&A2 in cell A3
and you got the result.
Similarly,
you wrote Ankit in cell A1 and Kalra in cell A2 and you want AnkitKalra result by
combining cell A1 and cell A2 in cell A3 then just type A1&A2 in cell A3
and you got the result.
More
use of & is explain in example of “”.