Range.PrefixCharacter (Excel)

Returns the prefix character for the cell.

If the TransitionNavigKeys property is False, this prefix character will be ' for a text label, or blank. If the TransitionNavigKeys property is True, this character will be ' for a left-justified label, " for a right-justified label, ^ for a centered label, \ for a repeated label, or blank.

Dim strPrefixCharacter As String
strPrefixCharacter = ActiveCell.PrefixCharacter