Find and copy data between ()
 

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

Find and copy data between ()
 

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

Find and copy data between ()
 

try:

=MID(G2,FIND("(",G2)+1,FIND(")",G2)-FIND("(",G2)-1)
--
hope to help,
cm


"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

Find and copy data between ()
 

Try this:

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

--
Biff
Microsoft Excel MVP


"Ty" wrote in message
...
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

Find and copy data between ()
 

This worked, Thanks
--
Thanks, Ty


"cm" wrote:

try:

=MID(G2,FIND("(",G2)+1,FIND(")",G2)-FIND("(",G2)-1)
--
hope to help,
cm


"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