On Fri, 8 Feb 2008 04:01:00 -0800, Antonio
wrote:

Hi all

Is there anyway to extract the contents of the penultimate filled cell

Tks in advance

Yes there is. But it depends on how your data is organized.

If your data is in column A, is contiguous (no blank spaces), then:

=OFFSET(A1,COUNTA(A:A)-2,0)

If your data is organized differently, then the method will be different.
--ron