It’s actually much more trivial than that. I’m attaching a video to demonstrate the specific behavior in excel. Notice the cursor placement in edit mode when it switches to edit mode.
UPDATE: unfortunately i cannot attach video files. Here’s the link from gdrive.
https://drive.google.com/open?id=1FhuZmgHpL8L7wTvzYxBFoE-jshyj4zgM