Remove blank cells or extract cells...

[nidiser]

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

[JBeaucaire]

1) Highlight the entire range of cells including blanks and filled in text cells
2) Press F5 and click on Special
3) Select Blanks and click on OK
4) Now click on Edit > Delete
5) Select Shift cells to left from the popup option window

[nidiser]

Hi, thanks for the quick reply.

In step 3 of the above I get an error

"No cells were found"

[nidiser]

found it. it seemed that the cell was not blank, but it was blank coming from a function. anyway, you helped a lot!

thanks.

case solved

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.