Get rid of apostrophes

[jaypatel]

Hi,

I have a column of data which is column B. What would be the code to get rid of all the apostrophes at the beginning of each cell from cell b1-b65536.

Cheers

Jay

 

[TommyGun]

Why not just do a Find & Replace [Ctrl+H], with a Find What equal to ', and a blank value in the replace field?

 

[jaypatel]

How about via a macro... as I would like this process automated.

Cheers

Jay

 

[Iridium]

TommyGun's answer is good enough but if a macro it must be then try

'The following procedure removes the apostrophe in front of text, values, or formulas in the current selection:
'Removes hidden apostrophes that are first characters.
'Works on cells with formulas, text, or values.
Sub ApostropheRemove()
    For Each currentcell In Selection
        If currentcell.HasFormula = False Then
            'Verifies that procedure does not change the
            'cell with the active formula so that it contains
            'only the value.
            currentcell.formula = currentcell.Value
        End If
    Next
End Sub

HTH