Thread
:
Removal of 100's of spacing in numbers
View Single Post
#
5
Posted to microsoft.public.excel.misc
Don Guillett[_2_]
external usenet poster
Posts: 1,522
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.
Reply With Quote
Don Guillett[_2_]
View Public Profile
Find all posts by Don Guillett[_2_]