Newline is added on exported Excel file cell values

%3CLINGO-SUB%20id%3D%22lingo-sub-3019623%22%20slang%3D%22en-US%22%3ENewline%20is%20added%20on%20exported%20Excel%20file%20cell%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3019623%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%3C%2FP%3E%3CP%3EI'm%20using%20Microsoft%20Forms%20to%20create%20excel%20files.%20I've%20noticed%20an%20issue%20where%20on%20%3CU%3Emultiple-choice%20questions%3C%2FU%3E%20if%20one%20of%20the%20answers%20is%20a%20sequence%20of%20numbers%20and%20letters%20separated%20by%20a%20space%20the%20value%20in%20the%20cell%20in%20Excel%20file%20will%20have%20a%20newline%20character%20at%20the%20end.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20instance%2C%20a%20selection%20of%3C%2FP%3E%3CP%3E%222021-2022%20YR%22%3C%2FP%3E%3CP%3Ewill%20appear%20in%20Excel%20as%26nbsp%3B%3C%2FP%3E%3CP%3E%222021-2022%20YR%3C%2FP%3E%3CP%3E%22%3C%2FP%3E%3CP%3EThis%20requires%20tedious%20cleaning%20before%20we%20can%20use%20the%20files%20and%20feels%20unintentional.%20There%20doesn't%20seem%20to%20be%20any%20options%20for%20customizing%20the%20Excel%20files%20before%20they%20are%20exported%20from%20Forms.%20Is%20there%20a%20way%20to%20prevent%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3019623%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello!

I'm using Microsoft Forms to create excel files. I've noticed an issue where on multiple-choice questions if one of the answers is a sequence of numbers and letters separated by a space the value in the cell in Excel file will have a newline character at the end.

 

For instance, a selection of

"2021-2022 YR"

will appear in Excel as 

"2021-2022 YR

"

This requires tedious cleaning before we can use the files and feels unintentional. There doesn't seem to be any options for customizing the Excel files before they are exported from Forms. Is there a way to prevent this?

0 Replies