Cell string extraction of numbers only with varying length

[mingandmong]

Hi

Can anyone help with my query im using excel 2010

i require to extract a varying length of number's (max 7) form cell A into cell B from a string of both Alpha, numbers & symbols

Thankyou

[B]Sheet1[/B]

[TABLE]
 <colgroup><col style="font-weight:bold; width:30px;  "><col style="width:251px;"><col style="width:64px;"></colgroup><tbody>[TR="bgcolor: #cacaca"]
[TD]*[/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD="bgcolor: #cacaca, align: center"]1[/TD]
[TD="align: left"]'A. aaaAAA (11)[/TD]
[TD="align: left"]11[/TD]
[/TR]
[TR]
[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: left"]'B. BBBBbbb (222)[/TD]
[TD="align: left"]222[/TD]
[/TR]
[TR]
[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="align: left"]'c. cccCCCcc (333)[/TD]
[TD="align: left"]333[/TD]
[/TR]
[TR]
[TD="bgcolor: #cacaca, align: center"]4[/TD]
[TD="align: left"]'d. DDDDDDDdddd (4444)[/TD]
[TD="align: left"]4444[/TD]
[/TR]
[TR]
[TD="bgcolor: #cacaca, align: center"]5[/TD]
[TD="align: left"]'E. eeeeeeeeee (55555)[/TD]
[TD="align: left"]55555[/TD]
[/TR]
[TR]
[TD="bgcolor: #cacaca, align: center"]6[/TD]
[TD="align: left"]'f. FFFFFFF (666666)[/TD]
[TD="align: left"]666666[/TD]
[/TR]
[TR]
[TD="bgcolor: #cacaca, align: center"]7[/TD]
[TD="align: left"]'G. ggggggggggggggggg (7777777)[/TD]
[TD="align: left"]7777777[/TD]
[/TR]
</tbody>[/TABLE]
 
[URL="http://www.excel-jeanie-html.de/index.php?f=1"]Excel tables to the web - Excel Jeanie Html 4[/URL]

 

[adam087]

Are they always surrounded by brackets like that? If so..

Excel 2010
	A	B
1	'A. aaaAAA (11)	11
2	'B. BBBBbbb (222)	222
3	'c. cccCCCcc (333)	333
4	'd. DDDDDDDdddd (4444)	4444
5	'E. eeeeeeeeee (55555)	55555
6	'f. FFFFFFF (666666)	666666
7	'G. ggggggggggggggggg (7777777)	7777777
Sheet1

Cell Formulas
Range	Formula
B1	=VALUE(MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(", A1)-1))

/AJ

 

[Special-K99]

=mid(a1,find("(",a1)+1,find(")",a1)-find("(",a1)-1)

 

[mingandmong]

Are they always surrounded by brackets like that? If so..

Excel 2010

	A	B
'A. aaaAAA (11)
'B. BBBBbbb (222)
'c. cccCCCcc (333)
'd. DDDDDDDdddd (4444)
'E. eeeeeeeeee (55555)
'f. FFFFFFF (666666)
'G. ggggggggggggggggg (7777777)

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"]11[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]222[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]333[/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]4444[/TD]

[TD="align: center"]5[/TD]

[TD="align: right"]55555[/TD]

[TD="align: center"]6[/TD]

[TD="align: right"]666666[/TD]

[TD="align: center"]7[/TD]

[TD="align: right"]7777777[/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]B1[/TH]
[TD="align: left"]=VALUE(MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(", A1)-1))[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]



/AJ

THank-you AJ works just as i wanted

 

[adam087]

Perfect. Thanks for the feedback.

/AJ

 

[mingandmong]

=mid(a1,find("(",a1)+1,find(")",a1)-find("(",a1)-1)

Thankyou Special-K99 both yourself and AJ have resolved my issue