Extracting certain info from a cell

[DTMHibbert]

Hi All, hoping you can help me here -

[TABLE="width: 368"]
<tbody>[TR]
[TD="width: 368"]Bevan010: Available 255 / Required 424[/TD]
[/TR]
</tbody>[/TABLE]

The text above is an example of data that is exported from a system we use, what i would like to do is to grab the numbers of of this string into two separate columns.

so in the example above the spreadsheet would be

[TABLE="width: 500"]
<tbody>[TR]
[TD]Data[/TD]
[TD]Available[/TD]
[TD]Required[/TD]
[/TR]
[TR]
[TD][TABLE="width: 368"]
<tbody>[TR]
[TD="width: 368"]Bevan010: Available 255 / Required 424[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]255[/TD]
[TD]424[/TD]
[/TR]
</tbody>[/TABLE]

Could anyone help on two formulae that could extract the information needed.

Thanks

 

[Fluff]

Try
=TRIM(MID(SUBSTITUTE(A1," /",REPT(" ",100)),SEARCH("Available ",A1)+10,100))*1
and
=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",100)),100))*1

 

[DTMHibbert]

Works perfectly... thanks so much...

i did have a formula which got me by but lost this... yours use such a better solution.

Thanks

 

[Fluff]

Glad to help & thanks for the feedback