google-sheets

Google Spreadsheet - Not calculating numbers with space

I am trying to do a calculation of two cells, where one of them contains a number like this: 1 250.

If the number is written like that, and not 1250, then I cannot get the spreadsheet to do any calculations with it. Google suddenly do not treat it as a legit number anymore.

Why not just type 1250 instead of 1 250? Well, I am getting the cell values from a html import function.

Any good advice on how to get around this?

Solution

  • Try something like this:

    =Substitute(A2," ","")

    In this formula, A2 is a cell. You are finding any spaces in that cell and then replacing it with a "non-space".