ExcelBanter - Conditional Formatting/Array Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Conditional Formatting/Array Formula (https://www.excelbanter.com/excel-discussion-misc-queries/101001-conditional-formatting-array-formula.html)

SJT

Conditional Formatting/Array Formula

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

Conditional Formatting/Array Formula

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

SJT

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

All times are GMT +1. The time now is 08:37 AM.