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 bugging 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.