Apr 07 2021
08:24 AM
- last edited on
Aug 03 2023
06:41 PM
by
TechCommunityAP
Apr 07 2021
08:24 AM
- last edited on
Aug 03 2023
06:41 PM
by
TechCommunityAP
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.