Dear All,

I am facing the following difficulty in excel.

I have a table (matrix) as follows (for illustration purposes I will only use 4 rows, however the actual rows are more than 800):

BLANK BLANK abc BLANK
def BLANK BLANK BLANK
BLANK ghi BLANK BLANK
BLANK BLANK BLANK jkl

consistinf of blank and text cells as above.

I would like somehow to remove the blank cells, preserving the row number (i.e. not shifting cells up)

or,

I would like a way to extract the text cell from each line.

In both ways the results I am trying to find should be a column like this

abc
def
ghi
jkl


Any ideas?

Thanks