Conditional deletion of cell contents

  • Thread starter Thread starter Colin Hayes
  • Start date Start date
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
 
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.
 
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
 
Back
Top