Thanks!

I tried it, but get "Microsoft Excel cannot calculate a formula. Cell
references in the formula refer to the formula's result, creating a circular
reference..."

??

"daddylonglegs" wrote:

For last text value in column A

=LOOKUP(REPT("z",255),A:A)

"Bagheera" wrote:

I'm trying to create a formula that will retrieve the text from the last cell
containing text in a column. No calculation necessary. Trying to keep the top
cell in a column updated with whatever the last entry in that column is...

Bruce