How to extract data from brackets, [xx] and amend them?

Hi there,

I currently have a forumula that can extract info out from () but have no idea on how to amend it to extract it from [] or {}, can some kind soul kindly advise?

In Cell A1 => A.F.P. PROVIDA SA - SPONS ADR (PVD US)

In Cell A2, I key in the forumula below and I get PVD US, which is what I wanted.
=MID($A1,FIND("(",$A1,FIND(A1,$A1))+1,FIND(")",$A1,FIND("(",$A1,FIND(A1,$A1))+1)-FIND("(",$A1,FIND(A1,$A1))-1)

Question is, if the data is in
A.F.P. PROVIDA SA - SPONS ADR [PVD US] or A.F.P. PROVIDA SA - SPONS ADR {PVD US} format, how can I amend the formula to get the same thing as above?

Thanks !!

is that bit {xxx} or (xxx) at the end?

welcome to the forum. using your formula, just change all the round brackets to square ones:

Formula:

Please Login or Register  to view this content.

or maybe just:
=MID(A1,FIND("[",A1)+1,FIND("]",A1)-FIND("[",A1)-1)

thats not OR? thats instead of

Formula:

Please Login or Register  to view this content.

or shorter

Formula:

Please Login or Register  to view this content.