返回
-
标题
Line breaks cause User Attribute Report to use multiple lines in a cell -
说明
Carriage Line feeds in User Attributes cause malformation of a cell in csv reports in Microsoft Excel, leaving multiple lines, but the value should be displayed in one line. -
原因
The current csv export behavior is the recommended standard for the CSV Format.
-
解决办法
The carriage return character can be removed in excel using the find and replace dialog or the substitute function.
Please see examples of how to fix the formatting here:
https://www.ablebits.com/office-addins-blog/2013/12/03/remove-carriage-returns-excel/