Try this:

=INDEX(A1:G1,MATCH(TRUE,A1:G1<"",A1:G1))

ctrl+shift+enter, not just enter


"the dave" wrote:

Thanks in advance.
Which formula would work here?
I have 7 cells. In one random cell there is a random text value. I want the
text value from whichever cell it is in, to show up in my main cell where I
need the formula.