May 08 2024 06:06 AM - edited May 08 2024 07:37 AM
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 the second word is a linked word. For example, if the sentence says: "A new software package" and "software" has a link, the spreadsheet has it as: "A newsoftware package."
The HTML code uses one simple <div> tag per glossary entry, and no other formatting at the item level.
I have 800+ items in this glossary and hundreds of links, so I am editing every single item manually in the spreadsheet to add the spaces between the words. I am not looking forward to having to do all of this manual work each time I export!
Anyone have any ideas how I can change/fix this so it doesn't happen in the first place - or an easier way to fix them in the spreadsheet?
May 08 2024 06:30 AM
SolutionMay 08 2024 07:38 AM
May 08 2024 07:41 AM
May 08 2024 06:30 AM
Solution