Forum Discussion
files saving as Lastname uparrow J Firstname
Excel 365, sorry I thought it was tagged as that. I'm not familiar with .SharePoint, even whether I have it. How does it work? And wouldn't the naming still be an issue?
your tags were for Office 365 and Excel, (there are several different versions of Excel that can be used with Office 365).
A SharePoint list has a lot of similarities to an Excel Table, it just doesn't have all of the math, but for your purposes, you don't need that. Here are the instructions to get your started in case you are interested
https://support.office.com/en-us/article/Introduction-to-lists-0A1C3ACE-DEF0-44AF-B225-CFA8D92C52D7
Some nice things about Lists are that many people can work on it at the same time, you just need a browser, and it can be exported to Excel if needed
Well, I do have some files from my old Excel, but it's the ones that are converted or created in 365 that have the naming issue. How would using SharePoint help with that? I don't need to share these with anyone else, the only spreadsheet I might share hasn't had an issue, probably because the name has only letters and numbers, and it likely wouldn't work in SharePoint because it does have a lot of arithmetic in it. It also appears this would not be free.
So I still don't know why a comma is being replaced by an arrow and J in workbook titles, or have any idea how to fix it. Anyone?
Commas used to be an unsupported character in file names and would cause this problem, but MS has made many changes and now there are only a few characters that cannot be used. The easiest fix is to not use a comma in the file name, which is what i would recommend because this cause problems with other applications.
What version of OneDrive are you using? if you still have the old OneDrive synce client (groove.exe) you could be running into the fact that it did not support commas.
These articles could be helpful
Since you have Office 365, you have SharePoint and there would not be any additional charge