Remove Alpha Suffix

[cgmojoco]

What would be the easiest way to remove an alpha suffix from an alpha numeric string?

AA12412BB
Should return
AA12412

So basically looking right to left removing any characters after the last numeric character.

Does anyone know how to write this as a UDF? Or VBA sub? Or worse case, as a formula?

 

[Haseeb Avarakkan]

Try;

<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">AA12412BB</td><td style=";">AA12412</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet1</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">B1</th><td style="text-align:left">=REPLACE(<font color="Blue">A1,MATCH(<font color="Red">9,INDEX(<font color="Green">--MID(<font color="Purple">A1,ROW(<font color="Teal">INDIRECT(<font color="#FF00FF">"1:"&LEN(<font color="Navy">A1</font>)</font>)</font>),1</font>),</font>)</font>)+1,LEN(<font color="Red">A1</font>),""</font>)</td></tr></tbody></table></td></tr></table><br />

 

[cgmojoco]

Perfect, thank you!

 

[Haseeb Avarakkan]

Sorry; one mistake.

Change MATCH(9,... to MATCH(10,