Share via

Export sharepoint 2007 list to excel shows ids in people column

Question

Thursday, October 11, 2012 3:28 AM

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

All replies (1)

Thursday, October 11, 2012 6:47 AM âś…Answered | 1 vote

Hi Ravichandra,

I don't think you will get strainght answer of your question because this problem is still remain in 2010. when you export any looup column then you get the ID value with that and person or group column is lookup (which look into user information list).

You may remove ID from excel itself using VBA or formula. Check below similar threads if they can help you

http://stackoverflow.com/questions/5023686/cleaning-people-group-data-exported-from-sharepoint-2010-lists

http://go4answers.webhost4life.com/Example/export-sharepoint-user-groups-excel-55086.aspx

Hope it may help

Cheers, Hemendra-MCTS "Yesterday is just a memory,Tomorrow we may never see"