Guys,

3rd post on this now, and I have narrowed my problem down to this:

Function test () as String

test = "line1" & vbLf & "line2"

End


This function shows this in my Excel cell...

line1
line2

If I cut and paste it into notepad, it shows this...

"line1
line2"

I need to get rid of those quotation marks. If I take the vbLf out, i get
line1line2 and when I cut and paste there are NO quotation marks, so I know
it has to do with the fact that I put in the vbLf.

Is there ANY way I can still have my text formatted with carriage returns
when I cut and paste into Notepad WITHOUT getting those annoying quotation
marks?