How to remove a carriage return from a long text field for a csv file

Hello I have data generating from a table onto a csv file and it appears there’s a carriage return being entered in a Note field (long text) distorting the csv file.

How can we remove the carriage return so that it appears as simple text? Will changing it to a normal text box do the trick and if yes, how many characters can the user input into a text field vs. the long text?

0 8 2,855
8 REPLIES 8
Top Labels in this Space