Using your formula I get:
Public, John James, (middle name but no suffix); needing Public, John James
Smith, Jane, (No middle name, no suffix); needing Smith, Jane
Jones, John , III (middle name with suffix); needing Jones, John, III
Now when a record has a middle and suffix it returns...