Jeffrey Green
Well-known Member
- Joined
- Oct 24, 2007
- Messages
- 1,021
00080236528-GP0KA I need the leading zeros to go away. leaving me with
<tbody> </tbody> |
<tbody>
</tbody>
Last edited:
00080236528-GP0KA I need the leading zeros to go away. leaving me with
<tbody> </tbody> |
Book1 | ||||
---|---|---|---|---|
A | B | |||
1 | 00080236528-GP0KA | 80236528-GP0KA | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B1 | =SUBSTITUTE(TRIM(SUBSTITUTE($A1,"0"," "))," ","0") |
Darn I liked that solution.@ wideboydixon:
With your solution, 00080230008-GP0KA --> 802308-GP0KA
A B 1 00080236528-GP0KA 80236528-GP0KA
<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>Sheet1
Worksheet Formulas
Cell Formula B1 =SUBSTITUTE(TRIM(SUBSTITUTE($A1,"0"," "))," ","0")
<thead>
</thead><tbody>
</tbody>
<tbody>
</tbody>
WBD
Book1 | ||||
---|---|---|---|---|
A | B | |||
1 | 00080236528-GP0KA | 80236528-GP0KA | ||
2 | 00080230008-GP0KA | 80230008-GP0KA | ||
3 | 00080036500-GP0KA | 80036500-GP0KA | ||
Sheet94 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B1 | =LEFT(A1,FIND("-",A1)-1)+0&MID(A1,FIND("-",A1),255) |