I have a bunch of excel files that contain some values in column D
Whenever there are values in this format, with a dash: F12314J-67" (yes with an inch mark at the very end), they need to be replaced with something like : F12314J
I've been working on this for a while now and my code so far is not working. Below is what I have so far
Whenever there are values in this format, with a dash: F12314J-67" (yes with an inch mark at the very end), they need to be replaced with something like : F12314J
I've been working on this for a while now and my code so far is not working. Below is what I have so far
VBA Code:
Sub CleanUpOutlier()
Set rng2 = Range("A1").CurrentRegion
lr9 = rng2.Cells(Rows.Count, "D").End(3).Row
.Replace "F12314J-67", "F12314J", LookAt:=xlWhole
End Sub