Delet Zero

[SimonHughes]

Hello, how can one delete all zero's in a range when some numbers must NOT have the zero's deleted? The stand alone zero's must go but the zero's that are part of a number must stay. Find replace will just get rid of all zero's. Your help appreciated; I am using Excel 2010

Excel Workbook
	E	F
186	Old Part Number	Part Number
187	730728	2200413305
188	0	0
189	0	0
190	715957	2200412324
Panels

 

[Rick Rothstein]

Find replace will just get rid of all zero's.

That is not true. Select your cells , then call up the Replace dialog box, put 0 in the "Find what" field, leave the "Replace with" field empty, THEN click the "Options>>" button and put a check mark in the "Match entire cell contents" checkbox, AND THEN click the "Replace All" button.

 

[SimonHughes]

Terrific, many thanks Rick.