Hi,
I have a data set of the following form:
The code I used is:
Code
Range("C:D").Select
Selection.Replace What:=".", Replacement:=":", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Selection.End(xlUp).Select
Any suggestions on What modification I might need to do? [I'm using Excel 2013]
Have asked the same question at Mr.Excel forums at http://www.mrexcel.com/forum/excel-qu…plications.html