Formula Field: Detecting if Another Field Has Text; ""If Contains *, Then...

Here's my formula idea: I want [Full Name] to display First, Middle, Last... but only show [Middle Name] if there is text in the field. Currently it shows up as an extra blank space, which doesn't...