Find and extract text in a column of blank Cells

Hi All,

Good day to all.

How can i extract a text in a column of blank cells. Example, A1:A100 is the range, in A14 there is a text say AAA, how can i extract that text and put in cell B1.

Thanks in advance.

Maybe you can delete the empty rows

Please Login or Register  to view this content.

Dear All,

I got it anyway, thanks!

i used this formula

Please Login or Register  to view this content.

Array formula CTRL+SHIFT+ENTER