Usually, to post in this NG, I copy formulas from the function bar and paste
them into a message here.

However, IF I (in Excel 2007)
Select Show Formulas
Enter <alt-ENTER into the formula so it will split over two lines in the
function bar
Copy the formula from the CELL (and not from the function bar)

the result is as below:


"=MID(A1,FIND("","",A1)+2,FIND(CHAR(1),
SUBSTITUTE(A1,"" "",CHAR(1),2))-FIND("","",A1)-2)"


If I copy the same formula from the function bar, then:

=MID(A1,FIND(",",A1)+2,FIND(CHAR(1),
SUBSTITUTE(A1," ",CHAR(1),2))-FIND(",",A1)-2)

I might have thought this was by design, except that without the <alt-ENTER,
copying from the cell does NOT result in the quoting and double-quoting:

=MID(A1,FIND(",",A1)+2,FIND(CHAR(1),SUBSTITUTE(A1, "
",CHAR(1),2))-FIND(",",A1)-2)


Is this a bug?

If so, can someone report it to the appropriate people?
--ron