Super Simple Question

[MAME]

In excel, I am using this formula to concatinate the contents of cell A2 to B2, B3, B4, etc:
=$A2&B2

After the first cell gets this formula, I drag the cell down so that it applies to the entire column. However, I thought the '$' operator made A2 static and thus didn't change when I expanded the formula down the column.

I want it to be A2&B2, A2&B3, A2&B4, etc. but it turns out with the A's incrementing as well :|

 

[BeakerChem]

You need $A$2 to keep it constant.

 

[MAME]

ah christ, thanks

 

[BeakerChem]

No prob, do that sort of thing all the time.