Return text string from charcater start and end point

I am trying to return the first occurrence of a variable text string with-in brackets for all data on the spreadsheet using the "RIGHT" excel function, the text to search is in column D.

Example for cells D2 & D3 reads:

D2:Adv Costs (27a) - would return "27a"
D3:Designer Unit (60) (Base) (50abc) - would return "50abc"

Any help much appreciated.

Hi Dev
do you want the first or last occurrence - the first would be 60 in D3, not 50abc

Hi Nicky,
I was using the first occurrence based on using the "RIGHT" excel function as I thought this would be easier? however it would be the last occurrence not using this function.

this formula should return the contents of the first set of brackets in your string:

Please Login or Register  to view this content.

and this one should return the contents of the last set of brackets - sorry it's rather clunky, if a forum guru is around they can probably do something more elegant for you:

Please Login or Register  to view this content.

Cheers Nicky, works a treat.