IMPORTING FIRST NAME AND LAST NAME SEPARATE IN EXCEL

Re: Way to extract the leftmost as well as rightmost characters until first encountered sp

For first name
#REF!

For last name
#REF!