=SUBSTITUTE(A1," ","")

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


"Munfarid" wrote:

Hi there,

Could anyone please advise how to remove 'spaces' that are contained within
a number string in a cell?

e.g. 123 4545 4545

Please advise how to remove the spaces in between, with any function/formula
to obtain the desired result of '12345454545' i.e. by deleting the spaces.

Thanks