I have formula's that return text strings in A1:A7 (note these also
may return <blank. So there maybe text in A3 and A6 only or a
combination of any of the 7.

How could I return in A1, the 1st string returned from A1:A7, the 2nd
string in A2 etc etc

In my example of A3:A6 above, the value essentially given in A3 would
appear in A1, the value appearing in A6 would appear in A2 and thus
nothing in A3:A7?

I hope I have not described this in a very confusing manner

Thanks