$

“$”

Used for – “$” is used tell MS excel that a cell / row / column has been fixed for reference in a formula throughout the sheet in which the formula has been written.

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 1.2 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 Ankit Kalra result by combining cell A1 and cell A2 in cell A3 then just type A1&” “&A2 in cell A3 and you got the result.