Forum Discussion

DaveD11's avatar
DaveD11
Copper Contributor
Apr 07, 2021

MSTeams form choice list cuts words in half in excel

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.

No RepliesBe the first to reply

Resources