Find data between ()
 

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

Find data between ()
 

Is this different than your previous post?

for data in G2:

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

--
hope to help,
cm


"Ty" wrote:

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

Find data between ()
 

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

In article ,
says...

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?