Parse Full Name Field to First and Last Name Fields

Parse Full Name Field to First and Last Name Fields

I have data coming from another system as Full Name (e.g John Smith) that I need to parse to 2 fields, First Name and Last Name (e.g  John, Smith).  Is there any "easy" way to do this with a formula?

I thought I could just look for the first occurrence of a " ", but 1) I cannot figure out the formula or function to do this and 2) this does not handle situations where the are multiple spaces in the name (e.g  Mary Anne Van Der Beek - Maria Anne (first name) , Van Der Beek (Last Name)