How about just selecting the column and doing:
Edit|replace
what: 1
with: Yes
(check match entire cell contents under the Options button)
replace all
Edit|replace
what: (leave blank)
with: No
replace all
The blank cells in the used range will be changed.
Jerry Arnone, PMP wrote:
I have a field formated as general. The field contains either 1 or is left
blank. If the field has a 1 I want to replace it with Yes and if the field
is blank I want to replace it with No.
any help is appreciated.
--
Jerry
--
Dave Peterson
|