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.
<colgroup><col><col></colgroup><tbody>
</tbody>
Thanks,
Rashid
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