I need the same thing--remove spaces from phone numbers-I removed all the (
) and dashes. I don't understand the response below. I tried pasting the
below formula in the fx box, but nothing happened. I have Excel 2007. TIA
Mudbug


"Allllen" wrote:

You don't need VBA
Just use =SUBSTITUTE(A1," ","")
--
Allen


"Tromp" wrote:

Hi! I need the vba-formula to remove the spaces between phone numbers.
999 99 999 99999999
9 999 9999 99999999
99 99 99 99 99999999