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.