Why are the old reports coming out with apostrophes next to the cell entries?
its causing me more work!
Userlevel 6
+2
Ah, I thought it was just me. Will be glad to know why.
Userlevel 7
+6
That’s weird - you can filter those quickly as they are a way of escaping the value in a cell. Older reporting tools must not be getting the attention necessary to keep the escaping accurate.
Here is a fix that you can apply in one swoop - “reimport” the data in the table by selection your columns/rows and then using the Text to Columns feature that is part of Data Tools in Excel. The image below is one of the toolbar in excel 365. You will be given the prompt about the information being delimited...and you can tell excel to ignore the ‘s.
Thanks for the suggestion - but that was the very thing causing me more work as currently I'm having to download a number of reports. I'd rather not have to spend extra time using the text to column feature.
Reply
Log in to Docebo Community
Enter your email address or username and password below to log in to Docebo Community. No account yet? Create an account
Docebo Employee Login
or
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.