removing "/" from cell

[Godders199]

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

 

[vmjan02]

Try this code to replace "/" with ""

Selection.Replace What:="/", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False

 

[Godders199]

thanks that works, I just need to change the column format to text first, as it changes the numbers to

7.81742E+15

<tbody>
</tbody><colgroup><col></colgroup>