G
Guest
Hi there,
I have a column in an excel spreadsheet that is populated with one of two
things:
1. Normal text: i.e. words, numbers, addresses, etc...
or
2. A single 0 (zero)
What I want to do is execute a Find/Replace or similar command that will
eliminate the text in the cell if it is a single zero _without_ deleting any
other zeroes in any of the other cells.
Doing a simple find/replace does get rid of the zeroes in the "zero cells"
but also gets rid of zeroes in other cells (so -- like an address that has a
number 12007 becomes 127).
In smaller spreadsheets, I can simply hand-delete the "zero cells" but now
I'm starting to get spreadsheets that are over a thousand lines long and
hand-deleting is not time effective.
Thanks very much in advance!!
I have a column in an excel spreadsheet that is populated with one of two
things:
1. Normal text: i.e. words, numbers, addresses, etc...
or
2. A single 0 (zero)
What I want to do is execute a Find/Replace or similar command that will
eliminate the text in the cell if it is a single zero _without_ deleting any
other zeroes in any of the other cells.
Doing a simple find/replace does get rid of the zeroes in the "zero cells"
but also gets rid of zeroes in other cells (so -- like an address that has a
number 12007 becomes 127).
In smaller spreadsheets, I can simply hand-delete the "zero cells" but now
I'm starting to get spreadsheets that are over a thousand lines long and
hand-deleting is not time effective.
Thanks very much in advance!!