Illegal characters accepted by Quick Edit - SharePoint 2016

JC 1

My office is using SharePoint 2016 and Office 2016.

I've noticed that when my clients are copy/pasting data from Word/Excel into SharePoint lists using Quick Edit in SharePoint lists, some invisible special characters get copied over which break some of the functionalities of Lists. For example, page navigation and column filters don't work on the page where the special character is found.

Is there a way clients can find and fix the problem characters on their own?

If not, is there a list of the characters the Edit form filters out but Quick Edit doesn't so I know what to clean up via script?

Thanks!

Edit:
So far, I've discovered the following unicode characters to cause problems:
0002 (start of text)
0007 (bell?)
0011 (vertical tab)
0030 (record separator)

Emily Hua-MSFT 27,601 Reputation points

2021-02-24T07:17:44.36+00:00

@JC
As this issue is more related to SharePoint, I would change the tag to be "office-sharepoint-server-itpro".
Thanks for your understanding.
Echo Du_MSFT 17,141 Reputation points

2021-02-25T02:56:24.35+00:00

Hello @JC ,

In my test, no similar issue occurred.

Can you tell me which characters in your document have problems or can you attach screenshots of the issue?

Have a nice day!

Thanks,
Echo Du

Share via

Illegal characters accepted by Quick Edit - SharePoint 2016