Forum Discussion
files saving as Lastname uparrow J Firstname
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
Sorry, we've been having issues around here, but back to this.
It appears I have up to date OneDrive for Windows 10, so that shouldn't be the issue. Without knowing the problem, I don't see any advantage to using SharePoint which must be different from Excel, else why would it even exist? I could leave out the comma, I suppose, but it would make the file names confusing, and it would be annoying to change them, delete all the old files, etc. I'd at least like to understand the problem before taking that route.