| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel function =if(istext(c25:c31),text," "). What is wrong?
Trying to have the text found in the range c25 to c31 added to a separate
cell. Only one of the cells in the range of cells c25 to c31 will contain text. The rest will always be blank. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel function =if(istext(c25:c31),text," "). What is wrong?
=C25 & C26 & C27 & C28 & C29 & C30 & C31
-- Gary''s Student - gsnu200831 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel function =if(istext(c25:c31),text," "). What is wrong?
If all the cells except one are blank, then you could do this:
=C25&C26&C27&C28&C29&C30&C31 Hope this helps. Pete On Feb 4, 12:04*am, Jerry wrote: Trying to have the text found in the range c25 to c31 added to a separate cell. *Only one of the cells in the range of cells c25 to c31 will contain text. *The rest will always be blank. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel function =if(istext(c25:c31),text," "). What is wrong?
The rest will always be blank.
Does that mean the cells will be *empty* or might they contain formulas that return formula blanks ("")? See if this does what you want: =LOOKUP("zzzzz",C25:C31) -- Biff Microsoft Excel MVP "Jerry" wrote in message ... Trying to have the text found in the range c25 to c31 added to a separate cell. Only one of the cells in the range of cells c25 to c31 will contain text. The rest will always be blank. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| how i convert "100" to "hundred"( number to text) in excel-2007 | Excel Worksheet Functions | |||
| How to change "automax" to "autosum"? (probablyl wrong terminology) | Excel Discussion (Misc queries) | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Linear Mode
