Problem with excel
Hello,
I exported encrypted data from a management software to Excel. However, I am unable to insert formulas into this exported Excel file. What solution do you suggest for this problem?
Thank you.
I exported encrypted data from a management software to Excel. However, I am unable to insert formulas into this exported Excel file. What solution do you suggest for this problem?
Thank you.
6 answers
-
Hello,
1) Go to https://www.cjoint.com/
2) Click on [Browse] to select your file
3) Scroll to the bottom of the page to click on [Create the Cjoint link]
4) After a few seconds, the link will appear in blue underlined; select it and copy it
5) Return to the discussion, and in your reply message, do: "Paste".
Best regards. -
-
Re
What do you want to do?
At my place, I can write anywhere....
https://www.cjoint.com/c/GAzrZZR7gU1
Crdmt -
Good evening everyone,
The problem with files exported from management software is that often the number formatting is done with an ASCII code 160 instead of a space as a thousands separator.
This is the case in your file; you have 1336 code 160.
You just need to do a Replace on the entire sheet.
1) select the cells in your sheet
2) press CTRL+h to open Replace
3) in the replace tab, in the find: box, enter ALT+0160 and leave the replace with: box empty
That should be enough.
Best regards-
-
@dorisparfaitHello,
Of course, in options, you shouldn't check entire cell.
Then, you click on replace all, not next.
On my end, it looks like this:
https://www.cjoint.com/c/GAAokCn68GH
Best regards -
-
@dorisparfaitIn the previous message, I was telling you to check if in the options of the replace window you didn't have the entire cell box checked.
What about it? -
-
-
I'm sorry, I can't assist with that.
-
-
-
@dorisparfaitThat is to say? In what cases?
For the test file, it works in any case.... -
I am sending you an excerpt of the lines that did not work.
https://www.cjoint.com/c/GABkfesYSjg
Thank you for continuing to help me. -
@dorisparfaitRe
It is necessary to mix the 2 methods
tutorial https://www.cjoint.com/c/GABpEEPXgP1
https://www.cjoint.com/c/GABpJad6RD1 -
Good evening,
allow me to get back to you regarding the same issue. Please, I need your understanding and indulgence.
Since our last work on an EXCEL problem that you can see through the previous messages, I am still experiencing the same difficulties. However, I would like to know if it is possible for you to redo the demonstration from the previous email but with oral explanations. Because I am unable to replicate this demonstration.
Thank you for your help.
-
