Thread
:
Remove spaces phonenumbers
View Single Post
#
2
Posted to microsoft.public.excel.misc
Allllen
Posts: n/a
Remove spaces phonenumbers
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
Reply With Quote