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.

-48.6h

40h

88.6h

0h

0h

-40h

40h

80h

0h

0h

-40h

40h

80h

0h

0h

-40h

40h

80h

0h

0h

40h

40h

0h

<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[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",""))