Thread: carriage return that works when pasted into a text file (eg. Notep
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chris Glen
 
Posts: n/a
Default carriage return that works when pasted into a text file (eg. Notep
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.
Reply With QuoteReply With Quote