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.

text string	Result
*1500WH	500
*1 59WH	59
*1305WH	305
*1 1WH	1

<colgroup><col><col></colgroup><tbody>
</tbody>

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