| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
REMOVE ZERO FILL
how can I remove zero fills?
000089 -- 89 0076---76 00HWY---- HWY |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
REMOVE ZERO FILL
Sounds like you have a special format applied to the cells. Select the cells
then Edit | Clear | Formats and see how they look. "ichihina" wrote: how can I remove zero fills? 000089 -- 89 0076---76 00HWY---- HWY |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
REMOVE ZERO FILL
Select your range Ctrl H Find What: 0 Replace With: leave blank
Replace All "ichihina" wrote: how can I remove zero fills? 000089 -- 89 0076---76 00HWY---- HWY |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
REMOVE ZERO FILL
Hi,
the answer is this formula: =substitute(A2,"0","") but what about if you have like below: 00005006 00189000 fg000pl noon0000 the above formula remove all zero's and for the above examples you will have: 00005006 = 56 00189000 = 189 fg000pl = fgpl noon0000 = noon does it work for you? Thanks, -- Farhad Hodjat "ichihina" wrote: how can I remove zero fills? 000089 -- 89 0076---76 00HWY---- HWY |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fill in form to type Item descrictions and costs and fill in funct | Excel Worksheet Functions | |||
| Edit Fill Series - How do I fill using minute increments | Excel Discussion (Misc queries) | |||
| I have a list of data, fill in the gaps. FILL function won't work | Excel Discussion (Misc queries) | |||
| The fill feature in Excel that gives option to fill or copy | New Users to Excel | |||
| How to fill colour in Excel, it appers No fill in my computer? | Excel Discussion (Misc queries) | |||
Linear Mode
