show me everything after the dot in excel

I have some thing like this:
1234.2568
i only want to see everything after the dot like in this case 2568.  how can i do this?
karinos57Asked:
Who is Participating?
 
GO-87Connect With a Mentor Commented:
=MID(A1,FIND(".",A1)+1,LEN(A1)-FIND(".",A1))
 
0
 
Patrick MatthewsConnect With a Mentor Commented:
karinos57,If you are looking for text, this formula returns the portion after ".", or an empty string if there is no period:=MID(A2,FIND(".",A2&".")+1,LEN(A2))Patrick
0
 
GO-87Commented:
or perhaps a little better,
=IF(ISERR(FIND(".",A1)),"",RIGHT(A1,LEN(A1)-FIND(".",A1)))
which will cope with cells that have no .
0
 
karinos57Author Commented:
thnx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.