Excel for Signalling
1) First, Separate log Assume this text is in A1 : 07/07/2026 00:00:09 - H,07072026,0000, Datetime column In B1 : =LEFT(A1,FIND(" - ",A1)-1) Result: 07/07/2026 00:00:09 Message column In C1 : =MID(A1,FIND(" - ",A1)+3,LEN(A1)) Result: H,07072026,0000, 2) VBA auto delete Press Alt + F11 → Insert → Module → paste this: Sub DeleteUnwantedLogRows_ByMessageColumn_Fixed() Dim ws As Worksheet Dim lastRow As Long Dim i As Long Dim msgText As String Set ws = ActiveSheet lastRow = ws.Cells(ws.Rows.Count, "B").End(xlUp).Row For i = lastRow To 1 Step -1 ' Skip kalau cell ada error value If Not IsError(ws.Cells(i, "B").Value) Then msgText = CStr(ws.Cells(i, "B").Value) If InStr(1, msgText, "All messages processed", vbTextCompare) > 0 _ Or InStr(1, msgText, "Transaction", vbTextCompare) > 0 _...