Formula Ideas

Copper Contributor

Hello!  I have a spreadsheet I am having brain fog getting a formula.  In the attached image in cell D2, I need a formula that will result in FALSE if the range E2:K2 shows numbers in any of the cells and TRUE if the range E2:K2 shows any text.  Any help is much appreciated!

 

2 Replies

@dschw2020 

In D2:

=ISERROR(--CONCAT(E2:K2))

or as an array formula confirmed with Ctrl+Shift+Enter:

=OR(ISTEXT(E2:K2))

Fill down.

Thank you!! That works perfectly!