View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Colin Hayes Colin Hayes is offline
external usenet poster
 
Posts: 465
Default 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