I know that the ISTEXT command will register a true response if there is any text in a particular cell.

Does anyone know of a way to do a similar thing for a range of cells so it will record a true response if there is any text in any cell in a range of cells?

My initial thought was to try =ISTEXT(B3:IL3) but that only seems to record if there is text in B3 and ignores what's going on with C3 through to IL3 - I figured it was worth a try though

I'm sure there is a really obvious solution but it's completely passing me by at the moment.

Many Thanks