Extra Spacing from Exporting to Excel

user077529
user077529 βšͺ️
in Card Building

Hello,

I have this issue where when I export to Excel, there is about 6 extra spaces at the end of each result.. When I export a card into Excel and click on a cell in the FirstName column, it'll show for example, "Max__", where _ = spaces.

Is there any way to get rid of this?

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon πŸ₯·
    Answer βœ“

    The export should just mimicking what is in your actual data, so I suspect you have trailing spaces in your source data. You can easily fix this in Magic ETL or with a Beast Mode by using the TRIM function to eliminate any leading or trailing spaces.



    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories