| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional deletion of cell contents
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. "Colin Hayes" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional deletion of cell contents
In article , Toppers
writes 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. Hi Ok , thanks for getting back. Can it be done with some VBA code , or by using a third column perhaps? Best Wishes Colin "Colin Hayes" wrote: 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 |
| Reply |
| 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) | |||
Hybrid Mode
