Your formula is replacing spaces with spaces
=SUBSTITUTE(A115," "," ")
Try changing that to..the below (Note the different between the find string
(" ") and replace string ("")

=SUBSTITUTE(A115," ","")
OR
=SUBSTITUTE(A115,CHAR(32),)


If this post helps click Yes
---------------
Jacob Skaria


"Munfarid" wrote:

May be the following with help you to understand the issue:

The cell A1 contain "4353495894385 ".
When i use the formula =LEN(A1), the result is "18"

but when i use the formula =SUBSTITUTE(A115," "," "), the result is also
comes at '18'. The result should rather be '13'. This indicates that the
later portion of the numberstring is appeared to be 'spaces' which the
substitute formula is not recognising.

I hope you got my point. If not, please advise.