Hello,
In my sample (sheet Turnover) I use the below mentioned code to delete the charahter "#" from column M (from some thousand cells), the code is working fine just too slow for me, do you have faster solutions?
Sub test()
Dim c As Range
Application.ScreenUpdating = False
For Each c In Worksheets("Turnover").Range("M9:M2294")
With c
If Left(.Value, 1) = "#" Then .Value = Left(.Value, Len(.Value) - 1)
End With
Next c
Application.ScreenUpdating = True
End Sub
The sample file has been added to this thread.
Thanks in advance your help!
Bookmarks