How to remove symbols( positive and negative) from alphanumeric numbers?

[vibinmvenugopal]

How to remove symbols( positive and negative) from alphanumeric numbers?

 

[Aladin Akyurek]

How to remove symbols( positive and negative) from alphanumeric numbers?

Any example with the associated expected outcomes?

 

[vibinmvenugopal]

I want to remove negative and positive signs and alphabets from the alphanumeric numbers. See eg below.

[TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]-48.6h[/TD]
[/TR]
[TR]
[TD]40h[/TD]
[/TR]
[TR]
[TD]88.6h[/TD]
[/TR]
[TR]
[TD]0h[/TD]
[/TR]
[TR]
[TD]0h[/TD]
[/TR]
[TR]
[TD]-40h[/TD]
[/TR]
[TR]
[TD]40h[/TD]
[/TR]
[TR]
[TD]80h[/TD]
[/TR]
[TR]
[TD]0h[/TD]
[/TR]
[TR]
[TD]0h[/TD]
[/TR]
[TR]
[TD]-40h[/TD]
[/TR]
[TR]
[TD]40h[/TD]
[/TR]
[TR]
[TD]80h[/TD]
[/TR]
[TR]
[TD]0h[/TD]
[/TR]
[TR]
[TD]0h[/TD]
[/TR]
[TR]
[TD]-40h[/TD]
[/TR]
[TR]
[TD]40h[/TD]
[/TR]
[TR]
[TD]80h[/TD]
[/TR]
[TR]
[TD]0h[/TD]
[/TR]
[TR]
[TD]0h[/TD]
[/TR]
[TR]
[TD]40h[/TD]
[/TR]
[TR]
[TD]40h[/TD]
[/TR]
[TR]
[TD]0h[/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

I want to remove negative and positive signs and alphabets from the alphanumeric numbers. See eg below.

...

B2. copied down:

=ABS(SUBSTITUTE(UPPER(A2),"H",""))