Author Posts

June 15, 2015 at 6:36 am

Hello,
I'm new in Powershell.
Well, with Excel I can select a column and repalce multi characters in 1 second. I would like to do the same thing with Powershell. With Excel it looks like this :

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".
Could you please help me ?

June 15, 2015 at 7:02 am

This was two days I was looking, I found, here is the solution:

 $ range.EntireColumn.Replace ('on', ';') 

.
Thank you.