I am not able to convert a text value of
5 205 with a middle blank space into
5205 in Excel. If I leave the value like this, my report chart with sum displays 0.
If I try to convert the text using the following formula:
it returns an error.
Even if I convert the cell to a number, it leaves the value as it is. My sum still returns 0.
=VALUE(SUBSTITUTE(B297," ","")) isn't working either.