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


    Tuesday, December 23, 2014 1:01 AM


All replies