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