display a single cell text from a range

Hi, 1st post for me this one as I have always managed to fanny my way around a problem.

Bit stuck with this one though. May be just a bit tired and brain not switched on?

Anyway, here goes...

I have a column of 20 cells. Only 1 of them has text in it. I want to scan down this column of cells and display at the bottom (i.e.cell 21) the text which is in the 1 cell that has text.
Only 1 cell in the column will have text at a time. I dont want a macro so a formula in the 21st cell would be great.

Anyone help.

Thanks in advance.

Royal Blue.