Formula trigger help needed

[droll]

I've created a formula by concatenating multiple cells which each contains pieces of the overall formula. Once I have the full formula concatenated in a cell I do a copy paste special - VALUE so it will create the text of the formula and eliminate the concatenate function. Once I get to this step I run into a problem. The only way I can trigger the formula is to edit the cell and press return. Only then do I get the results of the formula. Is there a way around having to touch each cell, because I have hundreds of cells to get the formula triggered.