Excel capability question

[janema]

Does anyone know if there is a formula or if Excel has the capability of returning just the last two digits of a number? For example:

If the field shows AB.ABCD.A1, is there a way to pull just the last two digits so it would be "A1" in the column next to. (The last two characters)

I know text to column can parse out characters and separate them out, but you have to select a space, tab, or punctuation to do that and there are no spaces between the characters. If I were to use the period (.), then it parses out multiple because there is a period in the beginning too. I need to pull the last two digits for over a thousand rows, so was wondering if anyone advanced in Excel knew of another way.

Thank you so much.

 

[Fluff]

As your profile shows multiple different versions of Excel, which one does this need to work in?

 

[janema]

As your profile shows multiple different versions of Excel, which one does this need to work in?

Microsoft® Excel® for Microsoft 365 MSO (Version 2211 Build 16.0.15831.20098) 64-bit

I think that is what you mean?

 

[Fluff]

Thanks for that.
How about

=TEXTAFTER(A2,".",-1)

 

[Sufiyan97]

If you always have comma at the end

Try

Book5
	A	B
1	AB.ABCD.A1,	A1
2
3
Sheet3

Cell Formulas
Range	Formula
B1	B1	=SUBSTITUTE(SUBSTITUTE(RIGHT(A1,3),".",""),",","")

 

[janema]

Thanks for that.
How about

=TEXTAFTER(A2,".",-1)

OMG, that worked!!! THANK YOU SO MUCH!!! I didn't know that was possible. You are AMAZING!

 

[Fluff]

Glad we could help & thanks for the feedback.