Have to go into edit mode, enter 100s of times, selecting + Ctrl + enter isn't option

I have hundreds of formula that were not able to occupy the cells with just the fill handle. My work around was to break up the formulas into multiple columns, modify as needed and then in Column A enter

Formula:

Please Login or Register  to view this content.

which then I drag the fill handle down. Then copy, paste as values and it displays the formula in the cell as it is shown in the edit area. To fix this I then put the cursor in the edit area, hit enter and the cell displays the formula result.
Is there any way I can do this to all of A column at once? The cells are not formatted as text.

upload.xlsm
Training plan sheet shows exactly what I am doing.

Originally Posted by FDibbins

why not?

It is because the training plan sheet is trying to organize data in a vertical manner, but the data in planning sheet isn't organized vertically but instead in individual blocks.

Finding and replacing the = with = worked to convert them all to fully functioning formulas.