Concatenate Formula not working for all rows

Hey all!

Excel Newbie here! I am trying to create a mass mailer using information that I collected on an Excel spreadsheet. I am having a major problem with the concatenate formula. When I plug in the formulate for the individual row, Excel spits out the correct information/format that I want.

The problem is that when I drag that formula to other rows, Excel just maintains the same information. So, I guess the problem is that Excel isn't automatically changing the formula that I had created. In the box that I have the formula in, I drag down the lower right hand cross down to all the rows that I want Excel to apply the formula to, but it's still the same info!

I have a feeling that this should be a simple fix. Maybe there's something wrong with the settings or something.

I am attaching a screenshot of what the issue is!

HELP and THANK YOU!

Jennifer