MSTeams form choice list cuts words in half in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2259038%22%20slang%3D%22en-US%22%3EMSTeams%20form%20choice%20list%20cuts%20words%20in%20half%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2259038%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20a%20form%20on%20MSTeams%20for%20employees%20to%20fill%20out%20with%20a%20few%20choice%20lists%20that%20allow%20for%20multiple%20selections.%20When%20I%20view%20this%20in%20excel%20all%20the%20choices%20are%20separated%20by%20a%20%3B%20(semicolon)%20with%20no%20space%20which%20then%20cuts%20words%20in%20half%20in%20random%20spots.%20I%20know%20that%20I%20can%20manually%20fix%20this%20once%20the%20information%20is%20in%20excel%20but%20is%20there%20any%20way%20to%20have%20the%20information%20auto%20populate%20in%20excel%20with%20a%20space%20between%20words%20so%20that%20it%20will%20not%20cut%20them%20in%20half%3F%20See%20screen%20shot%20for%20example.%20Also%2C%20at%20the%20end%20of%20the%20text%20there%20is%20always%20a%20%3B%20(semicolon)%20regardless%20of%20how%20many%20choices%20are%20selected.%20Is%20there%20anyways%20to%20automatically%20get%20rid%20of%20this%20as%20well.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2259038%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have created a form on MSTeams for employees to fill out with a few choice lists that allow for multiple selections. When I view this in excel all the choices are separated by a ; (semicolon) with no space which then cuts words in half in random spots. I know that I can manually fix this once the information is in excel but is there any way to have the information auto populate in excel with a space between words so that it will not cut them in half? See screen shot for example. Also, at the end of the text there is always a ; (semicolon) regardless of how many choices are selected. Is there anyways to automatically get rid of this as well.

0 Replies