Trim/Search Problem

[stephen567]

Hi Guys, Hopefully one of you will be able to help.

I have this data. e.g.

Smith,John (UK4569)
Bob,Billy (UKI8792)
Sam,Sammy (UK8974)

I am looking to pull back the 4 numbers in the brackets only, So I would need a formula that would find the close ) and then take the other for digits.

Anyone got any ideas?

 

[Andrew Poulsom]

Like this?

=MID(A1,FIND(")",A1)-4,4)

If you want a number rather than text returned add zero.

 

[VoG]

Try

=MID(A1,FIND(")",A1)-4,4)+0

 

[pgc01]

If the strings, like in the examples, always end in the 4 digit number plus a closing parenthesis:

=LEFT(RIGHT(A1,5),4)

 

[villy]

You can try...
supposed your data is in A

=MID(A1,SEARCH(")",A1)-4,4)

 

[villy]

Try

=MID(A1,FIND(")",A1)-4,4)+0

VoG,
Why is there a need for (+ 0)?
Thanks

 

[hiker95]

stephen567,

Excel Workbook
	A	B
1	Smith,John (UK4569)	4569
2	Bob,Billy (UKI8792)	8792
3	Sam,Sammy (UK8974)	8974
4
Sheet1

The formula in cell B1 copied down:
=MID(A1,FIND(")",A1,1)-4,4)

 

[villy]

Ok I didn't notice your explanation in before reply thanks anyway VoG

 

[stephen567]

cheers guys!!!!

Thanks very much for all your help.

 

[villy]

cheers guys!!!!

Thanks very much for all your help.

Glad I can help...WC