Find and copy data between ()

  • Thread starter Thread starter Ty
  • Start date Start date
T

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?
 
Try
=TRIM(LEFT(SUBSTITUTE(MID(G2,FIND("(",G2)+1,255),")",REPT(" ",255)),255))

If this post helps click Yes
 
Back
Top