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

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

Select your range
edit|replace
what: (spacebar)
with: (leave blank)
replace all

If you really need a macro, you can record one when you do it manually.

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

--

Dave Peterson

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

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(F2,"(",""),")"," "),"-","")
Look in the vba help index for REPLACE. Or, do an manual one for ( and for )
and for - while recording.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mudbug" wrote in message
...

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

-Don,
I'm sorry, I guess you have to dumb it down for me. The spaces are
different as below.

654 323 4657
844 50 3477
632 62 6630

What is vba? I tried searching the Help Index, but no luck.

Mudbug


"Don Guillett" wrote:

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(F2,"(",""),")"," "),"-","")
Look in the vba help index for REPLACE. Or, do an manual one for ( and for )
and for - while recording.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mudbug" wrote in message
...

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

It always pays to try to pull your ear lobe to turn on the brain to THINK.
Just add another parameter.
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(F2,"( ",""),")",""),"-",""),"
","")
VBA is macros which I guess you are not ready for.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mudbug" wrote in message
...

-Don,
I'm sorry, I guess you have to dumb it down for me. The spaces are
different as below.

654 323 4657
844 50 3477
632 62 6630

What is vba? I tried searching the Help Index, but no luck.

Mudbug


"Don Guillett" wrote:

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(F2,"(",""),")"," "),"-","")
Look in the vba help index for REPLACE. Or, do an manual one for ( and
for )
and for - while recording.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mudbug" wrote in message
...

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