Forum Discussion
files saving as Lastname uparrow J Firstname
I'm making files in Excel for lists of authors and their books. I'm trying to save them as Lastname, Firstname, but instead of the comma it puts an up arrow and a J. Why, and how do I fix this?
7 Replies
Some questions:
1. what version of Excel are you using?
2. have you considered using a SharePoint list instead of Excel? In many cases these lists provide much more functionality than what you get in an Excel file.
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
