get-childitem *.jpg | foreach { rename-item $_ $_.Name.Replace("bowl", "wooden-bowl-") } $search = 'help' $replace_with = 'contact' $base_dir = 'C:\Users\rosener\Desktop\a-temp\html-files' $text_file_ext = 'html' Get-ChildItem $base_dir -Recurse -Include "*.$text_file_ext" | ForEach-Object { (Get-Content $_.FullName) | ForEach-Object {$_ -replace $search, $replace_with} | Set-Content $_.FullName } Dim firstName, lastName As String Dim commaPosition As Integer Dim index As Integer For index = 2 To 8 commaPosition = InStr(1, Cells(index, 1), ",", 1) lastName = Left(Cells(index, 1), commaPosition - 1) firstName = Mid(Cells(index, 1), commaPosition + 2) Cells(index, 2) = firstName Cells(index, 3) = lastName Next index