Solved

show me everything after the dot in excel

Posted on 2010-08-26
4
472 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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Excel - Data Validation 3 30
VLOOKUP 6 18
Excel 2016 vba task to have certain column appear in certain rows 20 28
vba delete dups is not working 35 16
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

832 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