"Bob Phillips" wrote in message
...
You are clicking the target cell whilst still in edit mode, that is why
Excel thinks you are pasting that cell into the formula.

Do it this way:-
1) I want to copy part of a formula from a cell to another cell, which is
blank.
2) I highlight part of the formula.
3) I click control+c
4) Hit Esc.
5) Click the new, and paste



Thanks Bob! It worked! It also works if you hit "enter" instead of "escape"!

Julie