| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Eliminate digits in a product identification number
My current product number is 'ABC 0000030000030000--yes that is a label
identifier at the beginning of the id. I would like to eliminate the ABC, the leading zeros, and the four zeros at the end. However, this is the first number of thousands in the column--all of which change in those middle numbers that I need to retain. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to return first 3 digits of a number? | Excel Worksheet Functions | |||
| adding digits of a number | Excel Worksheet Functions | |||
| How Do I Eliminate the Serial Number for time from Date? | Excel Discussion (Misc queries) | |||
| How do I find the sum of all digits in a number? | Excel Discussion (Misc queries) | |||
| help with removing digits from a number | Excel Discussion (Misc queries) | |||
Threaded Mode
