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? thanks.

Hi, Thanks to share your post in this forum. Here are some useful links which I think would give you a proper hand: http://sarangasl.blogspot.com/2009/12/add-item-to-list-with-lookup-column.html. http://office.microsoft.com/en-us/access-help/import-from-or-link-to-a-sharepoint-list-HA001230313.aspx. Hope this could help you! Leo

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.

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.

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