Extract Data After Last Space

[muhammad susanto]

hi all..

how to extract data below after last spaces like this :
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC ;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC ;
}
.tableizer-table th {
background-color: #104E8B ;
color: #FFF ;
font-weight: bold;
}
</style>




[TABLE="class: tableizer-table"]
<thead>[TR="class: tableizer-firstrow"]
[TH]5010211001 - 1[/TH]
[TH]1[/TH]
[/TR]
</thead><tbody> [TR]
[TD]5010211006 - 12[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]5010211901 - 235[/TD]
[TD]235[/TD]
[/TR]
</tbody>[/TABLE]


anyone help, thanks in advance...

,sst

 

[AhoyNC]

Try:

Excel Workbook
	A	B
1	5010211001 - 1	1
2	5010211006 - 12	12
3	5010211901 - 235	235
Sheet

 

[muhammad susanto]

hi man....wow worked it like magic!!

thank you so much..

 

[Trebor76]

Hi muhammad susanto,

Assuming the data starts in cell A2 (change the following to suit), this will do the job:

=VALUE(MID(A2,FIND(" - ",A2)+3,255))

Fill down as required.

Regards,

Robert

 

[Rick Rothstein]

Hi muhammad susanto,

Assuming the data starts in cell A2 (change the following to suit), this will do the job:

=VALUE(MID(A2,FIND(" - ",A2)+3,255))

If the leading number is always 10 digits long like in the posted examples, then this simpler formula would also work...

=0+MID(A2,14,99)

 

[muhammad susanto]

hi Rick, thank you.. you're make different!!