Delete last character if letter

[dip11]

Hi,

I have a number of different codes which can be anywhere from 6 to 11 characters long and either end with a number or a letter.

What I want a code to do is to remove the last character if it is a letter only.

How would I do this?

[Bob Phillips]

You could try

=LEFT(A2,LEN(A2)-1)&IF(ISNUMBER(--RIGHT(A2)),RIGHT(A2),"")

[tom1977]

Hi in VBA try this:

Please Login or Register  to view this content.