I have two questions, PLEASE HELP:

1) I need to find & replace values within certain columns only, for the
entire workbook. I've tried selecting those columns before pressing CTRL + H,
but it still replaces values outside of the range. I've also tried each
setting of the advanced options, nothing works.

2) I need to replace values with a blank cell, I've tried "", and that
actually places "" in the cell, I also don't want to just enter a space,
because that's not actually blank, the space would be a character.

Thanks!