Yep...it's not just notepad, Access does this also (which is where I'm really
pasting to). Is there a way when I paste into Access that I can paste into a
formatted text box or something?

"Joel" wrote:

I found the real cause of the problem and why it is happening.

Forget the formula. If you type line1 and the Alt-enter (to get two lines)
and then type Line2

Line1 (Alt-enter)
Line2

Now copy these two lines into Notepade you get the double quotes. Notepad
is trying to keep the two rows of data together. Don't know the solution.

" wrote:

On 20 Sep, 16:30, 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?

Hi,

What about outputting directly to the text file rather than cutting
and pasting?

Function test() As String
Open "C:\Test.txt" For Output As #1
Print #1, "line1"
Print #1, "line2"
Close #1
End Function

This will then put in your text file:
Line1
Line2

James