none
Preventing the list item ID # from showing when Exporting a SharePoint list to Excel RRS feed

  • Question

  • In SharePoint 2013 I have exported a list to excel, however, as I have several lookup columns (including people/group selection) the information exported to excel in each of those columns also contains the ID # which I do not want.  ie.  95;# Fred Flinstone or 3;# Approved, etc)

    I simply want to see the contents chosen - Fred Flinstone or Approved NOT 95;# Fred Flinstone or 3;# Approved

    Thanks!

    Tuesday, December 23, 2014 1:01 AM

Answers

All replies