Good morning. I just wanted to find out if there is an easy way to copy just the numbers after a decimal point into a separte column.
For example: Our part number is 015957.084. 84 is the length of the assembly. I already have a column with the whole part number, now I want just the length in another column.
Thanks for your help.
Last edited by LaurenSmalley; 06-03-2011 at 09:27 AM.
The easiest method would be Text to Columns and use the "." as the delimiter.
If you want a formula...
=MID(A1,FIND(".",A1)+1,LEN(A1))+0
Last edited by jeffreybrown; 06-03-2011 at 09:07 AM.
HTH
Regards, Jeff
Hi
try Data - text to columns using the dot as separator, and do not import the part before the dot
Try
=RIGHT(A1,LEN(A1)-SEARCH(".",A1))+0
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
Try the below method
=A1-ROUNDDOWN(A1,0),this is an example if your original data is in cell A1 and you need to change as per your requirement.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks