Conditional Formatting/Array Formula
Thanks.
"Dave Peterson" wrote:
A formula won't be able to change those cells, but Edit|replace could work.
SJT wrote:
I have a range of cells (A1:A20) that contains either text string A or text
string B. I would like to write a formula that looks at the entire range and
changes text string B to text string A automatically. Can I do that? Thank
you in advance for your assisteance.
--
Dave Peterson
|