You can use the combination of RIGHT() or LEFT() with the FIND() function to find a specific character and get the corresponding string values before and after this character.
In the example below, we will get the first and last name of a person, using the space character.
Our form design is quite simple, with the full name on A1.
Using LEFT(A1,LEN(A1)-FIND(" ",A1,1)) for the first name,
and RIGHT(A1,LEN(A1)-FIND(" ",A1,1)) for the last name. Notice that we're looking for the space character with the blank space in between quotation marks (" ") with FIND.
The output is the first name and last name that is extracted from the full name.