Hello I have a large Range("F2:SF1500") were only numbers are imputed. I need a macro that will remove/trim any blank spaces before the number in this range. I currently have
However, this takes a very very long time and at times crashes. Not all cells in the range will have value and not all Values in cell will have black spaces before the number. I would like to see if VBA can locate and select the Cells in range which the values have blank spaces before the Number and then run the above to reduce the run time or If there is an alternate way of doing this.
any help is greatly appreciated .
VBA Code:
Sub Trim()
Selection.Replace " ", ""
End Sub
However, this takes a very very long time and at times crashes. Not all cells in the range will have value and not all Values in cell will have black spaces before the number. I would like to see if VBA can locate and select the Cells in range which the values have blank spaces before the Number and then run the above to reduce the run time or If there is an alternate way of doing this.
any help is greatly appreciated .