A way in Excel to select permutation data only allowing for certain type of sequence?

Hi cchelise
Try this ....

Option Explicit
Sub test()
Dim oRgx As Object, rCell As Range
Set oRgx = CreateObject("VBScript.RegExp")
With oRgx
    .IgnoreCase = True
    .Global = True
    .Pattern = "\w{2}\W\w{2}\W\w"
    For Each rCell In Range("A2:A10")
       If .test(rCell.Value) = True Then
        rCell.Font.Color = vbRed
      End If
    Next rCell
End With
End Sub

or this pattern

.Pattern = "^[SFOP]{2}['][SFPO]{2}['][SFOP]$"