Remove all spaces from a Column c

[MarkCBB]

HI there,

I Am trying to remove all the Spaces from a column, but for some reason some of the spaces are not being removed, this is the code that I am using:

Columns("C").Replace What:=" ", Replacement:=""

All of the spaces are before the numerical value i.e. " 812" or " 6"

 

[MarkCBB]

Hi there,

I tried this code but it didnt work, so they are probably not normal spaces :

For i = 32 To 32
 a = Replace(sh.Cells(rowID, 5), Chr(i), "")
 sh.Cells(rowID, 5) = a
 Next i

This code works well and alot faster than the other code:

Selection.Replace what:=Chr(160), replacement:=""

Thank you for your help.

 

[MarkCBB]

Sheet2.Columns("E").Replace what:=Chr(160), replacement:=""