I am pasting the following data file in a calc file
What I am doing is copy/paste the data in the spreadsheet using “space” as a column seperator.
Then I am trying to apply a simple SUM() command in a new column but I get zeros. The reason is that the imported data have a ' character at the beggining.
I’ve notice that when I remove the ' character everything is working as expected. I’ve also noticed that the power changes. I’ve tried to replace this character by using Ctrl + H but the character ' is not recognised. So the questions are
- How to get rid of these
'characters - Why the are inserted in the first place
