Find data between ()

[Ty]

trying to pull the data out of a cell where the data is between parentheses.

Example data in cell: C6653FN (HP 15) INK, 2/PK, BLACK
Desired output: HP 15

Is there a formula for this?

 

[cm]

Is this different than your previous post?

for data in G2:

=MID(G2,FIND("(",G2)+1,FIND(")",G2)-FIND("(",G2)-1)

 

[Dan]

=MID(A1,FIND("[",A1)+1,LEN(A1)-FIND("]",A1)-1)