Get first name from full name — Manipulating NAMES in Excel
If you need extract the first name from a full name, you can easily do so with the FIND and LEFT functions. In the formula below, name is a full name, with a space separating the first name from other parts of the name.
Note: this formula does not account for titles (Ms., Mr., etc) in the full name. If titles exist, they should be removed first.