Solved

show me everything after the dot in excel

Posted on 2010-08-26
4
473 Views
Last Modified: 2012-05-10
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?
0
Comment
Question by:karinos57
  • 2
4 Comments
 
LVL 4

Accepted Solution

by:
GO-87 earned 125 total points
ID: 33535429
=MID(A1,FIND(".",A1)+1,LEN(A1)-FIND(".",A1))
 
0
 
LVL 92

Assisted Solution

by:Patrick Matthews
Patrick Matthews earned 125 total points
ID: 33535438
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
 
LVL 4

Expert Comment

by:GO-87
ID: 33535466
or perhaps a little better,
=IF(ISERR(FIND(".",A1)),"",RIGHT(A1,LEN(A1)-FIND(".",A1)))
which will cope with cells that have no .
0
 

Author Closing Comment

by:karinos57
ID: 33535491
thnx
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question