&

“&


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  “”.