Hey guys, I have searched and searched and cannot seem to get this figured out (I do not use excel too often).

I want to combine two cells but one of the variables will remain constant.

For example: In column A I will have the words A2 = Fun, A3 = Cold, A4 = Bad. Then I will have another word in another cell such as B1 = Day. I want to combine these words together in their corresponding cells as follows: B2 = Fun Day, B3 = Cold Day, B4 = Bad Day.

Now, I have used "=A2&" "&B1" and that gives me B2 = Fun Day but when I click to drag that formula down it changes to "=A3&" "&B2". I need that second variable to remain B1 for the entire column.

Can someone please explain how this is done?