Finding text between two parenthesis

Tim Steele

I am trying to pull the text between two parenthesis and place in another field.  In the screen shot attached I am wanting to get the data between the two parenthesis in the "Requested by (NetID) field and place it in the "Requested by NetID").  In other words, I want "dj32" to be in the second field.  Anyone have any ideas on the formula.  I've tried a combination of MID, RIGHT, FIND but nothing I put together gets past an error message.

 

 

Thanks,

Tim

J. Craig Williams

Tim,

 

I can't see your screen shot.

 

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

 

might work.

This is looking at the [Text] column, row 23.

 

This will throw an error if the text is blank, so 

 

=IFERROR(MID(Text35, FIND("(", Text35) + 1, FIND(")", Text35) - FIND("(", Text35) - 1), "blank")

 

 

Craig

 

Tim Steele

Thanks Craig, I will give that a shot.  Appreciate the quick response and will let you know how it worked. -Tim

Tim Steele

Craig,

 

This worked perfectly.  Thanks.

 

Tim

J. Craig Williams

Tim -

 

You are welcome.

 

Craig