Formula to remove last digit if it's a number

<br /><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=";">Sum of Trade Capture</td><td style=";">Trade Capture</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style=";">Sum of Trade Capture2</td><td style=";">Trade Capture</td></tr></tbody></table><br /><br /><table 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">=MID(<font color="Blue">IF(<font color="Red">ISNUMBER(<font color="Green">-RIGHT(<font color="Purple">A1,1</font>)</font>),LEFT(<font color="Green">A1,LEN(<font color="Purple">A1</font>)-1</font>),A1</font>),8,99</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">B2</th><td style="text-align:left">=MID(<font color="Blue">IF(<font color="Red">ISNUMBER(<font color="Green">-RIGHT(<font color="Purple">A2,1</font>)</font>),LEFT(<font color="Green">A2,LEN(<font color="Purple">A2</font>)-1</font>),A2</font>),8,99</font>)</td></tr></tbody></table></td></tr></table><br />

Perfect, thank you AlphaFrog

A slightly trimmed version ..

=MID(LEFT(A1,LEN(A1)-1+ISERR(RIGHT(A1)/1)),8,99)

... and still another one:

=MID(LEFT(A1,LEN(A1)-(RIGHT(A1)<"A")),8,99)

...so you don't really need MID and LEFT....

=MID(A1,8,LEN(A1)-7-(RIGHT(A1)<"A"))

barry houdini said:

...so you don't really need MID and LEFT....

=MID(A1,8,LEN(A1)-7-(RIGHT(A1)<"A"))

Click to expand...

Not only more concise, but also still copes if A1 is long.

barry houdini said:

...so you don't really need MID and LEFT....

Click to expand...

Yes, it was just another dumb moment .

pgc01 said:

Yes, it was just another dumb moment .

Click to expand...

pgc, I hope you are not calling me dumb!

Peter_SSs said:

pgc, I hope you are not calling me dumb!

Click to expand...

Not at all. You've just shown kindness when you posted your formula. You understood what I'd post next and you did not want me to feel bad when I posted mine.