View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
 
Posts: 1,522
Default Removal of 100's of spacing in numbers

try

Sub replacespaces()
Cells.Replace " ", ""
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"cas" wrote in message
...
I want to be able to use the replace command, but it wont find the spaces
for me.

When I copy tables with numbers from various sources, I get spaces inside
and after the numbers. E.g. €œ1 234 €œ

I know the use of SUBSTITUTE and other functions, but it is not an
effective
way of working when there are so many columns. I have tried to change the
cell format to text, but still no luck in finding the spaces with the
replace
command.