Microsoft Office Forums - View Single Post - [Solved] How to get the Right function to return a string that has UPPERCASE letters only

macropod · 08-28-2014, 09:01 PM

You could use code like:

Code:

Sub Demo()
Application.ScreenUpdating = False
With Selection.Range
  With .Find
    .ClearFormatting
    .Replacement.ClearFormatting
    .Text = "[A-Z]{2,}"
    .Replacement.Text = ""
    .Forward = False
    .Wrap = wdFindStop
    .Format = False
    .MatchWildcards = True
    .Execute
  End With
  If .Find.Found Then
    MsgBox Right(.Text, 2)
  End If
End With
Application.ScreenUpdating = True
End Sub