We need to extract the transaction no. indicated by “No:” in the memo field within an excel file. For that, we can use the following formula for getting the required data in a separate column.
Formula: =IFERROR(MID(G2, SEARCH(“No:”, G2) + 3, LEN(G2) – SEARCH(“No:”, G2) – 2), “”)
