Request assistance with a formula to pull only the first name from a cell
Currently I have a form which helps me capture the First and Last name of the user among other information. The first and last name is captured in separate columns.
However, 1% of the user inadvertently enters their full name in the first name section. The way I am trying to get around this issue is to have another column to capture the first name and eliminate the additional details wherever present.
I managed to extract the cells which has a space after the first name, as below.
=LEFT([First Name]@row, FIND(" ", [First Name]@row) - 0)
However, I am not sure how to also capture the first names which are accurately entered in the same column.
Hoping the above makes sense.
Help Article Resources
Check out the Formula Handbook template!