If the cell wit the text in was A3
=SUBSTITUTE(A3," ","") would loose the spaces, but it would still b
formated as text
=SUBSTITUTE(A3," ","")*1 would turn it into a number, but you woul
loose leading 0 on phonenumbers. If you formatted to custom an
0000000000
it would produce a leading 0 but if other phonenumbers wee differen
lengths it would fail, it is better staying as text
Regards
Da