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