PrefixCharacter Property

expression.PrefixCharacter

expression    Required. An expression that returns a Range object.

Example

This example deletes all prefix characters from the active worksheet in Spreadsheet1.

Sub Delete_PrefixCharacters()
    Dim rngCell

    ' Loop through all used cells in the active worksheet.
    For Each rngCell In Spreadsheet1.ActiveSheet.UsedRange

        ' If a prefix character exists, delete it.
        If rngCell.PrefixCharacter <> "" Then
            rngCell.Value = rngCell.Value
        End If
    Next
End Sub