Separate First Name

Separate First and Last Names in an Excel Spreadsheet

we have data like this 

you see space common for each cell we can put a below formula for extract first name

in this picture, you saw we using Iferror function Iferror basically used to get the first name where name is single