Sub Macro1() Columns("B:B").Select Selection.Replace What:=" on ", Replacement:=";", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False End Sub
I know how to do it when it is like this : (what:="\"), but not for " on " (with space before and after "on".
This was two days I was looking, I found, here is the solution:
$ range.EntireColumn.Replace ('on', ';')
You must be logged in to reply to this topic.