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

If this post helps click Yes
---------------
Jacob Skaria


"Ty" wrote:

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?
--
Thanks, Ty