How to find the last right hand numbers

[texasalynn]

I am trying to figure on a formula to return the right x digits from a cell. The problem is that sometimes it will be the last 3 and sometimes the last 4. My data looks like this
01002BI732
01002BJ735
01002BK906
01002BP1101
01002BQ1116
01002BR1118
01002BW705
01002BY1325
So what I need is the numbers after the alpha. Does someone know how I can do this?

Thanks . . . texasalynn

 

[Smitty]

If your leading characters always number 7 as in your example, you could use Data-->Text to Columns-->Fixed Width & create a break line after the last alpha character.

HTH,

Smitty

 

[texasalynn]

Just but I need to leave that column as is

texasalynn

 

[Aladin Akyurek]

Just but I need to leave that column as is

texasalynn

So, would that not mean...

=--RIGHT(A1,LEN(A1)-7)

 

[Cbrine]

This will work as well

=IF(ISNUMBER(VALUE(MID(A1,LEN(A1)-3,1))),RIGHT(A1,4),RIGHT(A1,3))

This formula checks to see if the 4 character back is a number and uses that to determine where to do the right string to.

 

[texasalynn]

Well of course Aladin! I was over thinking it. Yours would be the simple answer and works.

Thanks . . . texasalynn

 

[rrdonutz]

Also:

=--REPLACE(A1,1,7,"")