Find and copy data between ()

[Ty]

Im trying to create a column that has only the data found in another column
that is between ().

EX: cell G2: C6653FN (HP 15) INK, 2/PK, BLACK

Output wanted: HP 15

what formula would find this?

 

[Jacob Skaria]

Try
=TRIM(LEFT(SUBSTITUTE(MID(G2,FIND("(",G2)+1,255),")",REPT(" ",255)),255))

If this post helps click Yes

 

[cm]

try:

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

 

[T. Valko]

Try this:

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

 

[Ty]

This worked, Thanks
--
Thanks, Ty

try:

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