Skip to main content
SharePoint

Return to Question

Commonmark migration
Source Link
Community Bot
Community Bot
  • 1

Has anyone come across this issue or dealt with ID numbers being exported from a lookup column? Is there a way that I can have the SharePoint list not export the numbers when I 'Excel export' the list?

List: [![enter image description here][1]][1]enter image description here

Excel Export: The red boxed ID are the ones that I would not like to include in the Export which are the Lookup columns. [![enter image description here][2]][2]enter image description here

All help on this issue would be appreciated. [1]: https://i.sstatic.net/1YNwI.png [2]: https://i.sstatic.net/lZBYD.png

Has anyone come across this issue or dealt with ID numbers being exported from a lookup column? Is there a way that I can have the SharePoint list not export the numbers when I 'Excel export' the list?

List: [![enter image description here][1]][1]

Excel Export: The red boxed ID are the ones that I would not like to include in the Export which are the Lookup columns. [![enter image description here][2]][2]

All help on this issue would be appreciated. [1]: https://i.sstatic.net/1YNwI.png [2]: https://i.sstatic.net/lZBYD.png

Has anyone come across this issue or dealt with ID numbers being exported from a lookup column? Is there a way that I can have the SharePoint list not export the numbers when I 'Excel export' the list?

List: enter image description here

Excel Export: The red boxed ID are the ones that I would not like to include in the Export which are the Lookup columns. enter image description here

All help on this issue would be appreciated.

Source Link
SLE
SLE
  • 273
  • 2
  • 8

Remove Lookup Columns ID's on list Excel Export

Has anyone come across this issue or dealt with ID numbers being exported from a lookup column? Is there a way that I can have the SharePoint list not export the numbers when I 'Excel export' the list?

List: [![enter image description here][1]][1]

Excel Export: The red boxed ID are the ones that I would not like to include in the Export which are the Lookup columns. [![enter image description here][2]][2]

All help on this issue would be appreciated. [1]: https://i.sstatic.net/1YNwI.png [2]: https://i.sstatic.net/lZBYD.png