Hi,
aa.bb.c -> c
aaa.bbb.c.dd -> dd
a.b.cc.dd.eee -> eee

I only need text after ". " from the very right side. I used =right(A1,find(".",A1)-1),this formula doesn't always work.
Could you please tell me how to do that ? Thank you !