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

[Butcher1]

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

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.

[FDibbins]

Can you show a sample of what you are working with, and what you are trying to do?

I cannot visualize your problem

I have hundreds of formula that were not able to occupy the cells with just the fill handle.

why not?

[Butcher1]

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

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.

[Butcher1]

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

[FDibbins]

wow that seems like way too much work, Im sure there is a way to automate that, 3 things spring to mind...
=OFFSET()
=INDIRECT()
=INDEX/MATCH

but because I dont really know what you are doing, you will have to try and explain to me, so I can see if 1 of these woll help you