People Lookup (multiple values) exporting to excel

  • 12 September 2019
  • 1 reply
  • 4 views

When I export my nintex form list to excel, the values in the people lookup fields come back as this: lastname, firstname MI;#10841.... I have been reading over things on google for the last 3 hours and cant seem to find a way to fix this. If it helps, the people lookup brings is set to show the name with presence.

I have another people lookup field that only allows for single values so I know it's got something to do with the multiple values but please help!


1 reply

Userlevel 6
Badge +22
Hi,
I do not think there is much you can do about how SharePoint exports to Excel.
One thing you can do is cleanup the excel sheet by using FIND and REPLACE functions.

Reply