| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clear Contents of Adjacent Cell on Conditional Basis | Excel Discussion (Misc queries) | |||
| Return cell contents based on conditional lookup | Excel Worksheet Functions | |||
| Conditional Format based on contents of cell. | Excel Worksheet Functions | |||
| Problem with Conditional format deletion | Excel Discussion (Misc queries) | |||
| #REF! after cell deletion | Excel Discussion (Misc queries) | |||
Threaded Mode
