Excel function =if(istext(c25:c31),text," "). What is wrong?

  • Thread starter Thread starter Jerry
  • Start date Start date
J

Jerry

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.
 
If all the cells except one are blank, then you could do this:

=C25&C26&C27&C28&C29&C30&C31

Hope this helps.

Pete
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF statement on a range of cells in Excel 2007 4
If statement with generic value 5
EXCEL 2000 - IF function returns wrong result from logical test 8
Embarrassing question about lookup. 4
How do I display text when a cell value is 0 for accounting? 2
Formulas in a range of cells 4
IF function, nested with 2 source cells? 5
How do I sort Library of Congress call numbers in Excel? 7

Back
Top