All of column B is empty except one cell. The non-empty cell is in a
different place each week. I want a formula that will give the text in the
nonempty cell, regardless of which cell is nonempty at that point in time.
For example.

Week 4
Cell should say "Text 4"

A B
1
2
3
4 Text 4


Week 2
Cell should say "Text 2"

A B
1
2 Text 2
3
4


Thanks