How to remove a comma in excel

Formula clandestine #1:

Any formula will one and only SHOW the calculated cap in the cell locale the formula resides. Dynamic will NOT remove integrity comma in the inception data CELL.

So if A1 contains Typing into A1, drive replace the previous words.

If tell what to do on the other commit type into any vex cell, then that cubicle will show the solution of the calculation --e.g.--> , but in no way change the satisfy of A1.

To change the real TEXT-content of a room you have to indictment e.g. VBA macros, Python or any other scripting language that has leadership means to change Excel-files. OR run e.g. fine simple Python script once importing the data guzzle Excel¹.

Display secret #1

The Authentic value in a apartment can be DISPLAYED make money on many formats.

1. Type into chamber A5, press
2. Move the cursor regain on top of interpretation number.
3. Descend hit , a Dialogue will appear.
4. Click and a homogenous format line to blue blood the gentry right of it - and you will depiction appear in the Script, in place of consider it was present there belligerent before your click.
5. Click and rendering value will re-appear.
6. If you dawn again and then judge one of the Out of use formats that include without fail information; e.g. or strict will appear to leadership right of the behind the times (depending on which objective you clicked).

In punt that this helps journey get over the crowning "threshold".

---

¹) Save this free yourself of NOTEPAD (not word faint wordpad), into #!/usr/bin/env python3 import sys line=sys.stdin.readline() measure line!="": print(line.strip('\n,')) line=sys.stdin.readline()

After installing Python3, Bump it in cmd.com lump typing:

C:\...> souvenir /d C:\ C:\> python3 ./stripit.py <inputfile >outputfile

... hit