none
Export sharepoint 2007 list to excel shows ids in people column RRS feed

  • Question

  • Hi,

    I have a SharePoint List which has a people column(multi select). When I try to export the list to excel, the people column shows name and id. I wnat it to be only name. How can i achieve this?

    Current Scenario:

    Title             People

    AAA             John,123;Scott,456;

    Expected Scenario:

    Title             People

    AAA             John;Scott


    Ravichandra Challa

    Thursday, October 11, 2012 3:28 AM

Answers