Excel search formula-return multiple results from a single cell?

Is it possible for the search formula to return multiple records found in a single cell?

For example, if I have the text “Project IDs (222) (333)” in A1, how can I make the following cell return both results found within parentheses?

My current formula which only returns a single first record found of 222, leaving out 333 is:

=MID(A1,SEARCH(“(“,A1)+1,(SEARCH(“)”,A1)-SEARCH(“(“,A1))-1)

Any help would be appreciated.