Thanks for your formula, however I have been advised you need to add *1 to
the end in order to return the cell to a numeric one

thanks for your help.

"Bondi" wrote:


Joco wrote:
I want to create a formular in a new numeric cell that removes spaces from
another cell ie 0800 123 456 result 0800123456

Hi Joco,

Maybe you can use something like this if your phonenumber is in A1

=SUBSTITUTE(A1," ","")

Regards,
Bondi