If we have about many sheets in excel, and save all the sheets as their own files will definitely was not about to do this by hand. it take a take time!. I found a good tips from the internet, to solve this problem,in which using the macro!.
Here the code:
Dim wbThis As Workbook
Dim wbNew As Workbook
Dim ws As Worksheet
Dim strFilename As String
Set wbThis = ThisWorkbook
For Each ws In wbThis.Worksheets
strFilename = wbThis.Path & "/" & ws.Name
Set wbNew = ActiveWorkbook
If we have the lines:
and we want final lines become like this:
we can applied notepad++ to do it. The solution as follow:
1) Using notepad++ and go to the search. Please used the regular expression as search mode
index\ means search for word; .* means everything else; $ means the end of line.
3) then replace with
4) That should find everything after (and including) index.php, and replace it with just index.php.