Scenario:

I have table_A that can contain 200 or more records. There is a field within table_A called "Notes" which is data type Memo/Long Text.

I would like to create a query that will look in table_A.Notes for an alphanumeric string - example: ABC12345678 and return that string separate of all the other text found within table_A.Notes.

The ABC part of that string is a PREFIX that I know (which I would like to use as match/search criteria if possible). The numbers part of the string are random. The length of the entire string is also unknown as it can change.

There may also be multiple instances of alphanumeric strings within one record - example: ABC12222, ABC1333, ABC998234. If this is the case I would like to be able extract and return all three strings.

These strings can also be anywhere within the Notes field - example: "Some text here ABC123345 some more text" or "ABC123345 some text here"

So far I have tried:

Left([table_A].[Notes],InStr(1,[table_A].[Notes]," ")-1)
in Expression Builder but this will only return the string if its found in the beginning and will not return multiple string instances.

I am open to achieving the results I want through either Expression Builder, SQL, or VBA but cannot say that I am an expert any of the three.