Well, I'm not sure how "smart" this is... But, I got the same results you
mention in your post when I attempt to past into Notepad. I couldn't really
find a way around it.

So, if I can't fix one side... Let's try the other.

Is there any reason you have to paste into NotePad?

What I did is simply use WordPad and PasteSpecial and chose Rich Text and I
seem to get the format you are looking for.

Just a thought...


"rfusee" wrote:

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?