I have a spreadsheet with numbers and text spread out across columns. I need
to search across the columns by row and return to the "A" column the first
value found either number or text. Is there such a formula?