View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Eric_MUC
 
Posts: n/a
Default carriage return that works when pasted into a text file (eg. Notep

Hi Chris,

not as far as I know.

But you could use a macro to write these rows in a text-file (even faster
than copying it manually ;) ).
There you can use e.g. vbLf or vbCr...

Did this help you?

Best wishes,
Eric

"Chris Glen" wrote:

Is this possible?

I'm concatenating several columns, and then copying that into a text file so
I can view it in Notepad. But I want a carriage return in there to break it
into two lines. CHAR(10) appears as a square in Notepad.