I'm exporting a list from SharePoint online that exports lookup columns and their ID which is impossible to change.
On Export, this is what it looks like:
[![enter image description here][1]][1]
Is there a way that I can write an Excel function to delete specific characters combinations?
I would like something similar to this `;#(Number between 1-2000)#` and `;#(Number between 1-2000)` to be deleted.
[![enter image description here][2]][2]
All help would be appreciated if this is possible somehow.
[1]: https://i.stack.imgur.com/OwcNz.png
[2]: https://i.stack.imgur.com/Dcqca.png
On Export, this is what it looks like:
[![enter image description here][1]][1]
Is there a way that I can write an Excel function to delete specific characters combinations?
I would like something similar to this `;#(Number between 1-2000)#` and `;#(Number between 1-2000)` to be deleted.
[![enter image description here][2]][2]
All help would be appreciated if this is possible somehow.
[1]: https://i.stack.imgur.com/OwcNz.png
[2]: https://i.stack.imgur.com/Dcqca.png
