Godders199
Active Member
- Joined
- Mar 2, 2017
- Messages
- 313
- Office Version
- 2013
Good morning, i have been trying various code, and copied some i have found on the internet, but am unable to get any to work.
I am trying to remove the character "/" from column i , which contains numbers in this format 111111/22/11111111///11
this was the latest attempt, is there a reason this is not working
lrow = 2
Do While (Cells(lrow, "A") <> "")
If Cells(lrow, "i").Value Like "/" Then
Cells(lrow, "i").Value = Replace(Cells(lrow, "i").Value, "/", "")
End If
lrow = lrow + 1
Loop
thanks
I am trying to remove the character "/" from column i , which contains numbers in this format 111111/22/11111111///11
this was the latest attempt, is there a reason this is not working
lrow = 2
Do While (Cells(lrow, "A") <> "")
If Cells(lrow, "i").Value Like "/" Then
Cells(lrow, "i").Value = Replace(Cells(lrow, "i").Value, "/", "")
End If
lrow = lrow + 1
Loop
thanks