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 !
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 !
Try
=TRIM(RIGHT(SUBSTITUTE(A1,".",REPT(" ",LEN(A1))),LEN(A1)))
Thank you so much. It works good !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks