Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need 2 formulas
1. a formula to do the following: in A1 is 00003056-021 I need B1 like this - if there are leading zeros then remove first 4 zeros (only 4 and not 5). I need B1 to have 3056021 without the dash. 2. a formula to do the following: in A1 is 30701267-042 I need B1 like this - if there are no leading zeros then remove digits 5-6-7-8 and the dash. I need b1 to have 3070042. Now, how do we combine both formulas? Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Graph Manipulation | Excel Discussion (Misc queries) | |||
Date Manipulation | Excel Discussion (Misc queries) | |||
Need Help with Cell Manipulation | Excel Discussion (Misc queries) | |||
Text manipulation | Excel Worksheet Functions | |||
Need help with some data manipulation | Excel Worksheet Functions |