Removing alphabets from range

[JOHN007]

can anyone help me out with a code to remove alphabets in a cells
example:

[TABLE="width: 239"]
<tbody>[TR]
[TD]input ----->[/TD]
[TD]output[/TD]
[/TR]
[TR]
[TD]ch0025[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]as234[/TD]
[TD]234[/TD]
[/TR]
[TR]
[TD]tr456[/TD]
[TD]456[/TD]
[/TR]
[TR]
[TD]az123[/TD]
[TD]123[/TD]
[/TR]
</tbody>[/TABLE]

 

[Marcílio_Lobão]

JOHN007, Good morning.

Try to use:

=MID(A1, 3, 100)*1

Is that what you want?

I hope it helps.

 

[JOHN007]

JOHN007, Good morning.

Try to use:

=MID(A1, 3, 100)*1

Is that what you want?

I hope it helps.

thanks for the reply. how ever i need a code which will remove alphabet form "ch0025ab" to '0025'

 

[István Hirsch]

Are there several series of digits in your strings or always only one? If there are, show us other examples.

 

[Marcílio_Lobão]

JOHN007, Good morning.

The suggested formula does exactly what was requested following the model presented.

In your new example besides removing any existing alphabets in the cell you want the result to be number or text?

Because to stay 0025 will have to be text.

In the previous example it seemed that a number result was desired.