Conditional deletion of cell contents
 

Hi

I need some help with a formula , please.

I need the content B1 to be deleted (or replaced with a space) if the
content of A1 contains the letters 'BT' or the number 19.

Any other content in B1 will be left intact in the absence of these in
A1.


Can someone help?



Best Wishes


Colin

Conditional deletion of cell contents
 

It can't be done with a formula as a cell either contains a formula OR data.
As B1 contains data, it cannot contain be replaced by a formula.

"Colin Hayes" wrote:

Hi

I need some help with a formula , please.

I need the content B1 to be deleted (or replaced with a space) if the
content of A1 contains the letters 'BT' or the number 19.

Any other content in B1 will be left intact in the absence of these in
A1.


Can someone help?



Best Wishes


Colin

Conditional deletion of cell contents
 

In article , Toppers
writes
It can't be done with a formula as a cell either contains a formula OR data.
As B1 contains data, it cannot contain be replaced by a formula.

Hi

Ok , thanks for getting back.

Can it be done with some VBA code , or by using a third column perhaps?



Best Wishes


Colin






"Colin Hayes" wrote:

Hi

I need some help with a formula , please.

I need the content B1 to be deleted (or replaced with a space) if the
content of A1 contains the letters 'BT' or the number 19.

Any other content in B1 will be left intact in the absence of these in
A1.


Can someone help?



Best Wishes


Colin