removing dashes and zeros

[kumar1803]

Hello

I need help with removing three zeros and dashes in between so I can get the exact number ( 6500203) in the first example below.

[TABLE="width: 120"]
<tbody>[TR]
[TD]00065-0002-03[/TD]
[/TR]
[TR]
[TD]00065-0006-03[/TD]
[/TR]
[TR]
[TD]00065-0096-05[/TD]
[/TR]
[TR]
[TD]00065-0215-35[/TD]
[/TR]
[TR]
[TD]00065-0246-10[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]

 

[shg]

[Table="width:, class:grid"][tr][td]Row\Col[/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][/tr][tr][td]

1​

[/td][td]00065-0002-03[/td][td]65000203[/td][td]B1: =SUBSTITUTE(MID(A1, 4, 10), "-", "")[/td][/tr]
[tr][td]

2​

[/td][td]00065-0006-03[/td][td]65000603[/td][td][/td][/tr]
[tr][td]

3​

[/td][td]00065-0096-05[/td][td]65009605[/td][td][/td][/tr]
[tr][td]

4​

[/td][td]00065-0215-35[/td][td]65021535[/td][td][/td][/tr]
[tr][td]

5​

[/td][td]00065-0246-10[/td][td]65024610[/td][td][/td][/tr]
[/table]