Most likely, it's a problem with the text being inserted and how Excel is interpreting the CSV data - namely the column delimiters. I'm guessing your weird column break issue occurs when the user has entered a comma into the text field. Unfortunately, I don't know of a reliable way to fix that except to strip any commas from the text using a formula and then downloading from a report that uses the formula instead of the original text.
------------------------------
Blake Harrison
bharrison@datablender.ioDataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 /
http://datablender.io/------------------------------
Original Message:
Sent: 01-06-2021 14:03
From: MATTHEW STOGNER
Subject: export to excel; one field to multiple rows
Hello,
When I attempt to export a report the result is it has the correct column names and initial data but one of the fields for a few records is getting put at the bottom in the first column under the other data in the report (this is happening when users put in a lot of text). The field type is a text-multi-line and I've tried putting a large number on the Max Character but that is not helping.
Has anyone experienced this? Is this an issue with Quickbase or Excel?
------------------------------
MATTHEW STOGNER
------------------------------