I have a string field that contains long text. The issue is when I convert that field to an excel, if a text has colon in between the string, the next text/string after the colon goes to the second row in excel. How do I update this field so when I export it to an excel, it stay on one row?
interesting, thanks. Do you, also, have to double-up any existing embedded double-quotes? or does Excel leave-alone anything not obviously a "wrapper"?
Not sure what you mean...are you getting an error or is it truncating or something else? Excel does have a limitation on how much data can exist in a single cell - if you are exceeding that limit then you need to figure out how to reduce the size of the column.
OK, but you've then lost all the line breaks in the text. You may not want them I suppose, but I'd fine a different way to "transport" the data into Excel so that the data wasn't modified in that way - i.e. if someone Copy & Pastes a single cell out of XLS they will have the benefit of the original line breaks.