When I export data of Cascaded Lookup column to Excel, there are some additionalcharacters. How to remove them?
Solution:
Please go to Central Administration > Application Management > Manage Web Applications, select the corresponding web application and click Manage Features on ribbon, then activate the Cascaded Lookup Data Adapter feature.
Applies for: SharePoint 2019, SharePoint 2016, SharePoint 2013, SharePoint 2010