How to find all the characters after the last dot in a text

[manish.agrawal446@gmail.com]

How to find all the characters after the last dot in a text

in the scenerio manish.agrawal.der.yup.mips it should display only mips

 

[NARAYANK991]

Hi Manish ,


Using Faseeh's answer to your earlier question , use this :


=IF(RIGHT(A1,1)=".","",RIGHT(A1,LEN(A1)-LEN(SUBSTITUTE(A1,".",""))))


where A1 has your string manish.agrawal.der.yup.mips


Narayan

 

[manish.agrawal446@gmail.com]

Hi,

This is not working

it fails in this exampls

manish.agrawal.xlsx

in this the above formula display only sx whereas it should display xlsx

 

[NARAYANK991]

Hi Manish ,


Sorry , my mistake.


Narayan

 

[manish.agrawal446@gmail.com]

=IF(RIGHT(A1,1)=".","",RIGHT(A1,LEN(A1)-LEN(SUBSTITUTE(A1,".",""))))


is not working

 

[NARAYANK991]

Hi Manish ,


The correct formula is :


=IFERROR(RIGHT(A1,LEN(A1)-FIND("|",SUBSTITUTE(A1,".","|",LEN(A1)-LEN(SUBSTITUTE(A1,".",""))))),"")


Narayan

 

[manish.agrawal446@gmail.com]

Thanks a lot. Its working fine