How to select all the cells with only ' in them

  • Thread starter Thread starter Colin Hayes
  • Start date Start date
C

Colin Hayes

Hi All

Column G has some cells which appear empty , but actually seem to have '
in them.

I'm trying to select just these cells using the 'Go To' interface.

Can someone advise how to do this?

I did trying multiplying the column by 0 , and then selecting blanks ,
but I found this didn't work.

Grateful for any advice.



Best Wishes
 
Column G has some cells which appear empty , but actually
seem to have ' in them.

I'm trying to select just these cells using the 'Go To' interface.
Click to expand...

Is your ultimate goal to remove the apostrophe and return these cells to
"normal" blanks? If so, here is a procedure that should work for you. Select
any blank cell (this would be a cell without the apostrophe in it) which is
formatted as General, then click the Format Painter icon (looks like a paint
brush... it can be found on the "Standard" toolbar in XL2003 and in the Home
tab, Clipboard panel in XL2007), then simply select the column containing
the cells having the lone apostrophes in them. Once you have done that,
these cells should now be normal blank cells again.

Rick Rothstein (MVP - Excel)
 
Hi All

Column G has some cells which appear empty , but actually seem to have '
in them.

I'm trying to select just these cells using the 'Go To' interface.

Can someone advise how to do this?

I did trying multiplying the column by 0 , and then selecting blanks ,
but I found this didn't work.

Grateful for any advice.

Best Wishes
Click to expand...

This little macro will select all cells on the worksheet that contain
only ticks:

Sub TickFinder()
Dim rTick As Range
For Each r In ActiveSheet.UsedRange
If Len(r.Value) = 0 And r.PrefixCharacter = "'" Then
If rTick Is Nothing Then
Set rTick = r
Else
Set rTick = Union(r, rTick)
End If
End If
Next
rTick.Select
End Sub
 
Back
Top