Conditional deletion of cell contents

C

Colin Hayes

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
 
T

Toppers

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.
 
C

Colin Hayes

Toppers said:
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.
Click to expand...

Hi

Ok , thanks for getting back.

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



Best Wishes


Colin
 
Top