Thread: Separate/ Remove digits from a string of Numbers
View Single Post
 
Old 07-23-2014, 02:55 AM
QA_Compliance_Advisor QA_Compliance_Advisor is offline Windows 7 32bit Office 2007
Advanced Beginner
  
Join Date: Jul 2014
Posts: 44
QA_Compliance_Advisor is on a distinguished road
Default Separate/ Remove digits from a string of Numbers
I have over 10,000 entries of part numbers with variable lengths for example
(1) 000
(2)00.00
(3)00.00.00

the rule I need is if the cell has a "." need to remove 2 from the right and if it has no "." need to remove 1.

Can anyone think of a formula that could do this, I have tried Left & Right Function but it only works to a certain degree.
Reply With Quote