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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
Comparing contents in three cells 1
concatenate contents of cells whose contents resemble cell referem 3
setting cell values based on a 3rd cell 4
compare three cells 1
Cell Content via Secondary Formula 2
Conditional formatting to a different cell and it contains a formula 7
Need Help 4

Back
Top