How do you replace an error (in my case, #N/A) with a space? The cell shows
that error until I type information into the cell next to it that gives it
information. I would like for the cell to remain blank until it needs to be
used. Is there a formula for this? I know I can keep it from showing when I
print, but I need to send this as an e-mail and do not want the error to
show. Thanks!