Solved

show me everything after the dot in excel

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

911 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

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now