Forum Discussion
Solved
Export to Excel Removes Spaces Before Links
I have exported a List from SharePoint to Excel. The list is a glossary of terms and the terms link to other terms in the list. In the exported spreadsheet, there isn't a space between words when ...
- I'm sure there is a better way, however as a workaround, you could create a workflow to copy the text into a plain text column and then export and remove/hide the original from the exported data. That is assuming the exported does not have the hyperlinks, which of my test it didn't. Another option would be to copy the data from the list into excel and use a formula to remove the additional HTML leaving only the text
I'm sure there is a better way, however as a workaround, you could create a workflow to copy the text into a plain text column and then export and remove/hide the original from the exported data. That is assuming the exported does not have the hyperlinks, which of my test it didn't. Another option would be to copy the data from the list into excel and use a formula to remove the additional HTML leaving only the text
Two excellent ideas. Thanks so much, Josh. I will give those a try.
- Happy to help I'd be Interested to see the solution, the workflow could also be used as an on going solution triggered when an item is created or modified