| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Well, how empty is it?
thanks
-- Gary''s Student - gsnu200768 "Don Guillett" wrote: try this logic to get to the last one =trim(a1) =len(trim(a1)) =if(len(trim(a1))<1,1,2) -- Don Guillett Microsoft MVP Excel SalesAid Software "Gary''s Student" wrote in message ... Is it possible, without VBA, to test the emptiness of a cell? For example, a formula that will return 1 if a cell is unused (has nothing in it), 2 if the cell has a formula returning a null string: =IF(1=1,,) 3 if the cell has a single quote in it and 4 otherwise? -- Gary''s Student - gsnu2007xx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clipboard empty but get cannot empty CB when trying to copy | Excel Worksheet Functions | |||
| why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
| in excel..:can't empty clip are" but already empty | Excel Discussion (Misc queries) | |||
| Excel - Autom. Filter "Empty / Non Empty cells" should come first | Excel Discussion (Misc queries) | |||
| How can I convert empty strings to empty cells? | Excel Discussion (Misc queries) | |||
Hybrid Mode
