Okay, looking at the example below:
472.1001.1000
472.1000
472.1001.5000
480.2000
I need to get the number after the first three numbers and period. I can't do a =right(9) because it will capture the first three when there are less than 9 characters. I just need everything after the first three. thanks.
Last edited by Mile029; 05-26-2011 at 11:41 AM.
Try
= MID(A1, 5,50)
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
And because this is excel, and there are a million ways to get at a solution;
If there is any variation on the leading characters before the period, you can take the range of cells that you're interested in and copy/paste them over to a .txt file, and then import them as period separated values. That would create the following
Please Login or Register to view this content.
Last edited by Miraun; 05-26-2011 at 11:39 AM. Reason: trying to make the columns quasi-line up for the example
yes, that's it, thank you
RIGHT(A2,LEN(A2)-FIND(".",A2)) I'm assuming it will always be the numbers after the first period you need. This will display all the numbers after that. If you add a +0 onto the end it will leave it showing as a useable number, you will then need to format the cell to display all the zeros
Windows 7 using Office 2007 & 2010
Remember your [ code ] [ /code ] tags, makes reading soooo much easier
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks