將log日志,復制到單獨一行 B列（可能一行很長，所以將整合后的放在A列）

使用公式可以篩選出 包含某些字符串的行 為true，將這些行直接刪除

=IF(COUNT(FIND("MediaMuxterThreadRussia",B2,1))>0,"包含","不包含")

=OR(ISNUMBER(SEARCH("MediaMuxterThreadRussia", B2)), ISNUMBER(SEARCH("dispatchKeyEvent:", B2)))
=OR(ISNUMBER(SEARCH("keyCode", B2)), ISNUMBER(SEARCH("D/y.e.a.a.i0: Read data:", B2)))
=OR(ISNUMBER(SEARCH("D/y.e.a.a.z:", B2)), ISNUMBER(SEARCH("/sys/class/leds/record", B2)))
=OR(ISNUMBER(SEARCH("Record Data Denoise:", B2)), ISNUMBER(SEARCH("Record Data Raw:", B2)))
=OR(ISNUMBER(SEARCH("send voice data:320", B2)), ISNUMBER(SEARCH("_MYT: OTG status:0", B2)))
=OR(ISNUMBER(SEARCH("operationComplete: 消息發送成功! cmd= 118, data length= 1298", B2)), ISNUMBER(SEARCH("I/SystemUtils_MYT: execCmd_2: cmd = echo", B2)))
=OR(ISNUMBER(SEARCH("sendAudioData: totalArray lenth= 1288", B2)), ISNUMBER(SEARCH("I/NettyClient_MYT: sendAudioData: groupid= 12713, istemp= 0", B2)))
=OR(ISNUMBER(SEARCH(" onReceivedAudioEvent: audioData length = 1280", B2)), ISNUMBER(SEARCH("processResponse: groupIdList id= 12713", B2)))

使用公式可以將某些長字符串 變成 短字符串

=IF(ISNUMBER(SEARCH("發送對講音頻數據", B2)), LEFT(B2, 100), B2)=IF(ISNUMBER(SEARCH("queueReceivedAudioData", B2)), LEFT(B2, 130), B2)

在Excel中，將公式直接拉到底的高效的方法

選中包含公式的單元格，按下Ctrl + Shift + 向下箭頭，即可快速選中整列并填充公式
選中包含公式的單元格和需要填充的區域，按下Ctrl + D，公式將向下填充。?

如何用Excel判斷單元格中包含任意一個字符