- Print
- DarkLight
- PDF
I just ran an export and the carriage returns in the comments caused them to flow to the next line instead of stay on the same line. How do I fix this?
Article summary
Did you find this summary helpful?
Thank you for your feedback
When I run exports in FIMS, my comments wrap to the next line when I open the data in excel. Is there any way to fix this?
Answer:
When you run an export, you are presented with several output options:
Choosing Excel will strip the carriage returns from the output.
Therefore, when you open the file in excel, the contents will fill up the cell and move to the next column to the right instead of moving to the next row.
Note that if designing your own export, large text block fields should be put at the end of the list so they can move to the right without impacting the other columns.
Also, another way to fix this issue is to remove the carriage returns in the Excel document.
Was this article helpful?