Clearing contents of only blank cells

**dwhite30518** · 06-27-2012, 05:23 PM

I have a worksheet that has some blank cells within a particular column. Eventhough these cells appear empty, they actually contain carriage returns. I have been trying to using the following code to clear the contents of these blank cells but it doesn't clear the contents. I can manual clear the contents but I really want to get this code to work because of the volume of blank cells I have to deal with.

Please Login or Register  to view this content.

Suggestions???

**Søren Larsen** · 06-27-2012, 05:43 PM

Try this:

Please Login or Register  to view this content.

**shg** · 06-27-2012, 05:48 PM

I'd try this:

Please Login or Register  to view this content.

**dwhite30518** · 06-27-2012, 06:00 PM

I tried

Please Login or Register  to view this content.

first, but nothing happened. I then tried

Please Login or Register  to view this content.

And had only one cell get affected by this. I still have 4 cells that contain carriage returns that this code did not work on. Any suggestions?

**shg** · 06-28-2012, 09:24 AM

Maybe there's something lese in those cells. Post a workbook?

**dwhite30518** · 06-28-2012, 09:26 AM

I have just copied the Column that I am working with. Cell A184 is the first example of the issue I am having.

**shg** · 06-29-2012, 09:35 AM

They are line feeds.

Select the column, do Ctrl+H, and put the cursor Find what box. Press and hold the Alt key, and on the NUMERIC keypad, type 0010

Leave the Replace box empty, press Replace All.