ExcelBanter - REMOVE ZERO FILL

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - REMOVE ZERO FILL (https://www.excelbanter.com/excel-discussion-misc-queries/134696-remove-zero-fill.html)

ichihina

REMOVE ZERO FILL

how can I remove zero fills?

000089 -- 89
0076---76
00HWY---- HWY

JLatham

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

Teethless mama

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

Farhad

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

All times are GMT +1. The time now is 07:04 PM.