Name Split receiving #VALUE! error

I have a column of names to split but I can't use "text to columns" because of credentials, etc. I've tried the following formula and it works where I have a first and last name available, but how do I get the first name to show if there is no last name, and leave the last name cell blank? Please see attached.