Generated and paste->values formulas not working

• I have an email list entered vertically into Excel
• This is list is being added to and subtracted from.
• I need to sort it occasionally.

I want to generate a list based off of this email list that will mass-enter these email addresses into an email group, so I have a formula to concatenate the cell on a row with a cell on the same row that contains "; ". I then concatenate this column of cells together to make my list to generate an email group.

I want the first concatenation look like this: if the first email address is mailto:aa@place.com, then the first concatenation would be "mailto:aa@place.com; ". No problem so far. I then copy this column and paste values in the next column. Then, when I concatenate that column of values together, to create the email list. Because I sort the email addresses according to a third column, I have to use $ in my calculations, so:: =CONCAT($B$3,$E$3). As I can't drag-copy this formula into the other cells in the column, I created a concatenation table where the row number increases by one for every row, generating a column of formula outputs that goes in order, =CONCAT($B$3,$E$3) then =CONCAT($B$4,$E$4), then =CONCAT($B$5,$E$5) and so on. I then copy this column, and past values. Here is where things go wonky. Excel pastes the values, but then does not calculate them. It even says there is something wrong with the formula. When I click on the cell, and leave the cell, the formula calculates just fine. I have automatic calculation selected.

Shown below is a sample. On row 44, I double-clicked into the cell, and then right out, and the formula calculated.

Excel formulas not calculating, unless I click into the formula cell

How can I get Excel to calculate these formulas without double-clicking into and then out of the cell 2000 times?

Thank you for your help.