Mayhaps the cells contain a space or spaces?

If that's the case you could use this macro to find and delete the extra
spaces.

The do your F5SpecialBlanks

Sub TRIM_EXTRA_SPACES()
Dim Cell As Range
For Each Cell In Selection
If (Not IsEmpty(Cell)) And _
Not IsNumeric(Cell.Value) And _
InStr(Cell.Formula, "=") = 0 _
Then Cell.Value = Application.Trim(Cell.Value)
Next
End Sub


Gord Dibben MS Excel MVP

On Fri, 2 Jan 2009 04:59:00 -0800, PointerMan
wrote:

Sorry for the lack of information. I have a spreadsheet with about 125
columns of data that I imported from Access. There are blank cells scattered
throughout the spreadsheet. When I look in a blank cell, it appears empty
but it won't get selected when I use the "Go To" function to select all the
blank cells. If I highlight the cell and hit the delete key, it'll show up
when I use the "Go To" function.

And yes, I essentially want to select the apparently empty cells and delete
their contents so that I can delete the cells and shift everything to the
left.


"Shane Devenshire" wrote:

Hi,

Not enough detail. Are the cells all in one column? Do you want to clear
the cells? Or do you want to delete them? And if you want to delete them do
you want to delete the cells or the entire row they are on? Show us an
example of your data.

If all the cells are in one column and you want to delete their entire rows
then:

1. Select the column of data and choose Data, Filter, AutoFilter
2. Open the drop down for the autofilter and choose Custom
3. From the first box choose "less than" in the second box enter 1
4. Select all the visible cells in the column and press Ctrl+- (control
minus)
5. Either choose Entire Row or Shift cells up depending on whether you want
to remove the individual cells of the entire rows. Or press Del if you just
want to clear the cells.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"PointerMan" wrote:

I need to eliminate all cells with a value less than 1, but I don't know how.
Can anyone help explain this to me?

Thanks!