On Wed, 19 Sep 2007 13:58:04 -0700, rfusee
wrote:


I have a Cell in Excel which calls a VBA function which returns a long
string. The VBA function works correctly and the output looks correct in the
Cell. When I copy and paste that cell from Excel into Notepad, it adds
quotation marks around the beginning and end of the text. I can't figure out
how to make it so that doesn't happen.

Furthermore, if I copy and paste the adjacent Cell in Excel, which is also a
long string but one which I typed directly into the cell and not from a VBA
function call - there are not quotation marks around the text in Notepad!

Very, very frustrating...any help would be most appreciated...

I can't reproduce with a 100 character string. Can you post the code your
using, or a simplified version that exhibits the same behavior?
--
Dick Kusleika
Microsoft MVP-Excel
http://www.dailydoseofexcel.com