Excel macro recording DOES NOT record actions but results! Useless.

I am very puzzled by the Excel macro recording mechanism. I am trying to record a sequence of actions that I use to edit a cell. For example, I have many cells like these

Please Login or Register  to view this content.

So the sequence is: F2 (to edit cell); Home (to go to first character); Ctrl+Shift+Right arrow (to select number); Del (to remove number); ENTER (to go to cell below).
It works, manually, but when I record it, that stupid macro mechanism ignores the actions and simply stores the content of cell. So if I apply the macro to another cell it simply stores in that cell the same value, making all cells the same! I am really astonished. It makes no sense to record the results, but the actions that, applied to different cells, generates different results!
Practically, instead of

Please Login or Register  to view this content.

I get

Please Login or Register  to view this content.

Unfortumately macro recorder does not record actions within cells. So instead of relying on what is recorded, you have to write code yourself. for instance such simple code shall do:

Please Login or Register  to view this content.

Select a starting cell (but not go into edit mode -> so no F2 key) and run the above macro

When you enter edit mode, which is what will happen when you press F2, code execution will stop as will the macro recorder.

Also, the macro recorder will not produce code with a loop.