In a report I have a cell that contains logs. In that series of logs I want to extract the part where it says "Transaction ID:111-2222".
I tried using the following function but it does not work systematically as the number I'm looking for is not always in the same position within the cell.
=IF(COUNTIF(A2;"*Transaction ID:*");MID(A2;127;7);"no")
Any ideas? Thanks!