Separate/ Remove digits from a string of Numbers

		Microsoft Office Forums > Microsoft Excel > Excel
Separate/ Remove digits from a string of Numbers

FAQ

Thread Tools

Display Modes

07-23-2014, 02:55 AM

QA_Compliance_Advisor QA_Compliance_Advisor is offline

Windows 7 32bit Separate/ Remove digits from a string of Numbers

Office 2007

Advanced Beginner

Join Date: Jul 2014

Posts: 44

QA_Compliance_Advisor is on a distinguished road

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.

Tags

left & right function, remove digits, separate

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Display Numbers in CSV file over 15 digits	linan123	Excel	1	06-24-2014 01:54 PM
How to extract only numbers from a STRING?	Learner7	Excel	3	07-02-2013 06:25 AM
Separate heading numbers	darksupernova	Word	16	03-02-2013 06:09 AM
Separate the digits into 3 combinations	Jasa P	Word VBA	1	08-19-2012 11:04 PM
Problems merging in last 4 digits of an account higher than 16 digits	Glynda	Mail Merge	1	04-08-2011 12:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:20 PM.