I seem to have a glitch in my spreadsheet. It doesn't show up when the spreadsheet is open in XL but when I open it in statistical software for analysis, I'm having problems working on the data, specifically, I can't categorise one of my columns with three options into subsets. Do you know what the issue could be and if so, how it can be fixed?

Thank you

Hi BrookeA,

Based on your description, I have several questions want to ask:

1. Did you do this operation in Excel? Or other applications?
2. >> the spreadsheet is open in XL <<, whats the meaning of XL? Is this a .xl file or a third-party add-in?
3. >> statistical software <<, is this a third-party add-in?

please be a bit more precise explain your requirement or you can upload a screenshot so that I can get more accurate solutions to this problem.

If you have no verified to post the screenshot, I suggest you upload the screenshot via OneDrive.

Or you could send this screenshot to our email address:

ibsofc@microsoft.com I'd like to help you check it.

Please Note: The email subject you should use the URL or the Title Name of your case.

Im glad to help and follow up your reply.

Regards,

George Zhao
TechNet Community Support