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 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.”
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?
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.”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? Read More