Jun 05 2019 12:59 PM
Hi, looking have a large file with data that looks like such..
B3:78/2
B3:78/3
and so on...
I want to change them as quickly as possible to look like
B3[78].2
B3[78].3
Can I change all at once, certain aspects of data in cells rather than have to do them one at a time?
Specifically, changint the ":" to "[ ]" and the "/" to "."
Jun 05 2019 01:25 PM
Hi Deen,
you can do it with the following macro - look at the attached file, too.
Sub ReplacePart()
With Sheet1
.Range("A:A").Replace What:=":", Replacement:="[", _
LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=True
.Range("A:A").Replace What:="/", Replacement:="].", _
LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=True
End With
End Sub
Best regards from germany
Bernd