I write a macro action that, for instance, goes as follows: F2 (to amend a
cell) shift key and back four spaces (to select the last four letters in that
cell) ctrl C (to copy these letters), back space (to delete them) right arrow
(to move to the next cell) ctrl v (to paste the last four letters into the
new cell), down arrow and left arrow (to get to the cell below where I
started). When I run the macro it runs exactly as before, but instead of
amending the current field as I wanted, it replaces what was in that field
with what was in the field I recorded the macro originally. I have tried
everything but cannot get this to do what I want.