Try this:

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

--
Biff
Microsoft Excel MVP


"rdp" wrote in message
...
I need a formula that will allow me to show the text in the last cell of a
column in another cell at the top of that same column. I have found one
that
works for numbers but not text.

Any suggestions?