While Export Excel file, Unwanted Character and Numerics coming in the Export Excel File

Question

While I am Export Excel file from Sharepoint List, Unwanted Character and Numeric coming in the Export Excel File for example in the People Column , email ID coming as johar,v,varsha;#58 , this # and Numeric coming under all entries, cant find any relatable answer, can please help to sort out this

Answer 1

Hi JoharVVarshaCSNR-8408,

The openspec-* tags are dedicated to supporting issues related to open specifications. You can find open specifications here https://learn.microsoft.com/en-us/openspecs/

Since your question does not pertain to one of these specifications, I've removed the openspecs tag and added the office-sharepoint-server-itpro tag. Hopefully this will get your post the proper attention.

If I've misunderstood your question and you believe this is related to the Open Specifications documents, please clarify, providing the document name and section with which you have the question or issue.

Best regards,
Tom Jebo
Sr Escalation Engineer
Microsoft Open Specifications

Answer 2

Hello @Johar,V,Varsha,CSN R ,

The special characters are ";#Num" represent the user’s ID tag in current SharePoint site. It's by design and we cannot change it.

I understand that you want to remove ";#Num" in excel file.

You could choice create a Person or Group column and unable allow multiple selections.

Thanks,
Echo Du

===============

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.