mingandmong
Active Member
- Joined
- Oct 15, 2014
- Messages
- 339
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
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
Code:
[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]