Ron Rosenfeld wrote:
After pasting in the formula, delete all the <LF's and it should work OK.
--ron

I deleted non-printing characters first in a text editor, then pasted in
a cell. I got the same result editing the paste in Excel.

Did it work for you?