I have been searching and having not found what I need. Basically this will be added to a "data dump" file from one of our systems. we need to search one of the fields, and this field is a free form Notes field. So there is really no defined structure, hence my problem. I need the ability to extract a specific kind of criteria within this cell.

1) It will always begin CAS-
2) Currently there are 8 numbers after, but open cases may have 7 and we may be at 9 soon
3) The notes field MAY have no case #s listed, only 1, or there may be multiple (I have seen in excess of 20 cases listed
4) The case # can be listed anywhere within the notes field, there is 0 consistency from the users.

The Formula will be added to Column AS and the notes are in column AP. There are 2 note samples, Each note of different length with the Case # in a different location, and one example shows 2 cases. If there are multiple cases, I need them all to display in the extract. Can anyone help please?

A sample of a note:
Salary modified by training error. CAS-12345678, sent to Payroll

Another sample
DM resolved that "ee processed with 8/26 start date
CAS-22117755
Hire case 9/9/19
EDM resolved as "processed"
note from HR in CAS-66098778