On Mar 15, 2017, at 2:00 PM,Chip Scheide wrote: > I am trying to export some data to tab separated format. > it is possible that there are carriage returns in the data. > Is there a character (or combination) that I can use to replace the > return to get excel to automatically wrap the text into one cell?
“Space" will work and had no cross-platform macOS/Windows Excel issues. I do this whenever You might also try option-space if you are on macOS. That used to represent a “hard space” that some Mac software would recognize and treat like a “soft return”. You would have to do some testing to verify how current versions of Excel handle this and how it is handled on Windows. On Windows Excel will handle alt-Enter as a special line break character. But I believe this is just a LF — line feed, char(10) — character so it may be problematic since end of record delimiters are typically CR+LF. Tim ******************************************** Tim Nevels Innovative Solutions 785-749-3444 [email protected] ******************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
