Hi,
Highlight the column, press CTRL H, Find what enter and space, don't enter
anything in replace with, hit replace all

if this helps please click yes, thanks

"dpgfb" wrote:

I have a column of phone numbers which are in the format 111 222 3333 and
need to reformat them with no spaces 1112223333. Any ideas?