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
Bookmarks