Hello! I need some help. I’ve tried to use the AI formula generator but I can’t get this formula to work. My goal is taking column 1 ‘Name’ which either has First + Last Name or First Name only. My goal is to extract the first name into a new column ‘First Name’. When there is a space between first and last name, I want the text before the space. When there is no space and therefore no last name I want everything within that first column. Ex: If column ‘Name’ = Jane Doe, I want the new column ‘First Name’ to populate Jane. If column ‘Name’ = Jane, I want the new column to pull Jane. Below is the formula which works for Jane Doe examples but not the Jane examples. All first name only entries show a (!) error in the formula column.