remove characters from text string

[rashid67]

I want a formula which remove first "*1" from the string and then remove "WH" for the text string.

Here is the example and the desired result.

[TABLE="width: 148"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]text string[/TD]
[TD] Result[/TD]
[/TR]
[TR]
[TD]*1500WH[/TD]
[TD="align: right"]500[/TD]
[/TR]
[TR]
[TD]*1 59WH[/TD]
[TD="align: right"]59[/TD]
[/TR]
[TR]
[TD]*1305WH[/TD]
[TD="align: right"]305[/TD]
[/TR]
[TR]
[TD]*1 1WH[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]

Thanks,
Rashid

 

[JoeMo]

Excel Workbook
	A	B
1	text string	Result
2	*1500WH	500
3	*1 59WH	59
4	*1305WH	305
5	*1 1WH	1
Sheet6