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
|