Replace data in a whole column as Excel This topic contains 1 reply, has 1 voice, and was last updated by René-Pierre Parot 3 years ago. Author Posts June 15, 2015 at 6:36 am #26458 René-Pierre ParotParticipant 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 #26459 René-Pierre ParotParticipant This was two days I was looking, I found, here is the solution: $ range.EntireColumn.Replace ('on', ';') . Thank you. Author Posts You must be logged in to reply to this topic.