easy way to remove all letters?

[joeloveszoe]

hi
i have cells that look like this - what is the fastest way to remove all letters with out using find & remove one letter at a time?
thanks in advance so much for your help
=) happy friday!!!!

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Helvetica}table.t1 {border-collapse: collapse}td.td1 {border-style: solid; border-width: 1.0px 1.0px 1.0px 1.0px; border-color: #cbcbcb #cbcbcb #cbcbcb #cbcbcb ; padding: 0.0px 5.0px 0.0px 5.0px}</style>[TABLE="class: t1"]
<tbody>[TR]
[TD="class: td1"]PFX84029
[/TD]
[/TR]
[TR]
[TD="class: td1"]ABFBK407
[/TD]
[/TR]
[TR]
[TD="class: td1"]CRD84893
[/TD]
[/TR]
[TR]
[TD="class: td1"]CRD32112
[/TD]
[/TR]
[TR]
[TD="class: td1"]CRD32122
[/TD]
[/TR]
[TR]
[TD="class: td1"]CRD32132
[/TD]
[/TR]
[TR]
[TD="class: td1"]CRD32142
[/TD]
[/TR]
[TR]
[TD="class: td1"]GLW42113
[/TD]
[/TR]
[TR]
[TD="class: td1"]GLW42113BLU
[/TD]
[/TR]
[TR]
[TD="class: td1"]GLW89097BLU
[/TD]
[/TR]
[TR]
[TD="class: td1"]PFX84025GW
[/TD]
[/TR]
[TR]
[TD="class: td1"]PFX32211
[/TD]
[/TR]
[TR]
[TD="class: td1"]GLW28904
[/TD]
[/TR]
[TR]
[TD="class: td1"]PFX50903EE
[/TD]
[/TR]
[TR]
[TD="class: td1"]GLW39624BLA
[/TD]
[/TR]
[TR]
[TD="class: td1"]PFX27895
[/TD]
[/TR]
[TR]
[TD="class: td1"]PFX52374EE
[/TD]
[/TR]
[TR]
[TD="class: td1"]PFX52674EE
[/TD]
[/TR]
[TR]
[TD="class: td1"]PFX01131
[/TD]
[/TR]
[TR]
[TD="class: td1"]GLW84058
[/TD]
[/TR]
[TR]
[TD="class: td1"]GLW41613
[/TD]
[/TR]
[TR]
[TD="class: td1"]PFX27909
[/TD]
[/TR]
[TR]
[TD="class: td1"]GLW42213
[/TD]
[/TR]
[TR]
[TD="class: td1"]GLW28900
[/TD]
[/TR]
[TR]
[TD="class: td1"]PFX27899
[/TD]
[/TR]
[TR]
[TD="class: td1"]PFX89551BLU
[/TD]
[/TR]
[TR]
[TD="class: td1"]GLW55633BLA
[/TD]
[/TR]
</tbody>[/TABLE]

 

[sheetspread]

Try this:

=MID(LEFT(A1,8),MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),20)

That's the most versatile solution since the sample data appears to have no breaks, e.g.:

Excel 2010
	A	B
1	PFX8402J9	8402J
Sheet2

Cell Formulas
Range	Formula
B1	=MID(LEFT(A1,8),MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789")),20)

But Dryver14's is pretty good for those who have Excel 2013 and later.

 

[jproffer]

Except that it left "J" in the resulting string. If I'm understanding right, he wants to skip the "J" and just have 84029.

I know his/her original data didn't have the "J" in it.....but if it had. Just thinking outloud.

 

[sheetspread]

Yes, hopefully the actual data contains no breaks either.