How to remove the group ID of a lookup column when exporting SharePoint list to Excel? RRS feed

  • Question

  • I am exporting my SharePoint list with a people/group column and another lookup column to Excel spreadsheet. The problem is, in addition to the content of these two column, the group ID (from the lookup lists) of these two columns show after like "Jack Smith #45". I really need remove these numbers. I tried to use Excel formulas, but i found it very difficult since both of these two columns allow multiple choice. Any ways?


    • Edited by Mike Walsh FIN Thursday, November 25, 2010 6:27 AM swearing removed
    Wednesday, November 24, 2010 9:05 PM


All replies

  • Hi,

    Thanks to share your post in this forum.

    Here are some useful links which I think would give you a proper hand:



    Hope this could help you!


    • Marked as answer by Leoyi Sun Thursday, December 2, 2010 8:46 AM
    Thursday, November 25, 2010 10:35 AM
  • Why did this maked as an answer?  Providing links to unrelated pages aren't answers.  I too would like to know how one exports to Excel with Lookup fields but not with the user/group IDs.  Did Microsoft actually test these features? Again MS provides only half uselful features in SharePoint while overlooking obvious issues.

    Saturday, March 19, 2011 5:48 PM
  • This was marked as the answer because a week went by after it had been posted and the original poster (i.e. the starter of the thread) had not come and said that it did not solve his problem.

    In fact the original poster still hasn't come back.

    While you may object to waiting only for a week before deciding the original poster must be happy with the reply as he didn't come back and say it didn't answer his question, the fact that he did not come back does usually indicate that he IS satisfied with the answer received.

    That's why it was marked as an answer - it is the only answer here.

    If you feel you have a related question, start a new thread.

    As far as the original poster is concerned this question of *his* is clearly answered as otherwise he'd have by now said that it was not answered.

    (another) Moderator.

    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Saturday, March 19, 2011 8:38 PM