extract numbers help

[cvgreports]

I got the following example on a cell A3:

John Smith (JS685V)

And what I need is just the data in between the brackets. I can do a RIGHT(A3,8), but I get the brackets as well and I just need the numbers & letters. I got over 200 entries like this. They all consist of 6 characters both letters and numbers. Thanks for the help.

 

[VoG]

Try

=MID(A3,FIND("(",A3)+1,LEN(A3)-FIND("(",A3)-1)

 

[cvgreports]

Try

=MID(A3,FIND("(",A3)+1,LEN(A3)-FIND("(",A3)-1)

I had a feeling it involved FIND and LEN, but I couldn't figure out how to put it together. Thanks a bunch.

 

[T. Valko]

I got the following example on a cell A3:

John Smith (JS685V)

And what I need is just the data in between the brackets. I can do a RIGHT(A3,8), but I get the brackets as well and I just need the numbers & letters. I got over 200 entries like this. They all consist of 6 characters both letters and numbers. Thanks for the help.

Try this...

A2 = John Smith (JS685V)

=MID(A2,FIND("(",A2)+1,6)

 

[VoG]

They all consist of 6 characters

Either I missed that or it was added as an afterthought whilst I was composing my formula

 

[scottylad2]

a alternative

Excel Workbook
	A	B
1	John Smith (JS685V)	JS685V
2	albert stein (p012345)	p012345
3	jock Brown (253458)	253458
Sheet2

 

[cvgreports]

man you guys rock, VoG your formula working perfectly fine. So many ways to create a formula. I love it...