How to remove special character without disturbing other character

[yakooza]

To all sifus out there, how can i transfer from these:


NAS517-3-2
-41353913
NAS517-3-5
NAS517-3-4
-42MS27253-2
-43353908
-44357182

To these:

NAS517-3-2
353913
NAS517-3-5
NAS517-3-4
MS27253-2
353908
357182

Thanks in advance.

 

[cml19722000]

To all sifus out there, how can i transfer from these:


NAS517-3-2
-41353913
NAS517-3-5
NAS517-3-4
-42MS27253-2
-43353908
-44357182

To these:

NAS517-3-2
353913
NAS517-3-5
NAS517-3-4
MS27253-2
353908
357182

Thanks in advance.

p/s: started at G5, place this formula to H5

=IF(LEFT(G5,2)="-4", MID(G5,4,10),MID(G5,1,10))