Deleting spaces

[floricita]

Hi,

I have a few hundred telephone numbers all like this

07730 967 876

I need to clean that up so it doesn't have the two spaces in it.

Is there anyway to do this please?

I.E need it to look like

07730967876

Thanks

[teylyn]

Hello,

in another column

=SUBSTITUTE(A1," ","")

copy down. Copy results, use Paste Special > Values to paste over original column. Delete helper column.

cheers,

[floricita]

Thanks mate.

However, after pasting values, some of them are numbers stored as text. Is there anyway to convert them but while keeping the 0's at the beginning?

[DeepakS]

Select the column, press Cntrl+f. Click on Replace, type single space in Find what field, leave Replace with field blank. Click Replace All.