Ragic Logo
<< Usage of the TEXT() formulaTable of ContentsUsing the Enter and Tab keys while entering data >>

Getting string values before and after a specified character in Ragic

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.

Top of Page
<< Usage of the TEXT() formulaTable of ContentsUsing the Enter and Tab keys while entering data >>
Learn more about Ragic:
Why we created Ragic
Webinars
User Guide
Keep in touch:
Blog
Email
Facebook
Twitter
Ragic, Inc.
1-888-666-8037
Terms
Privacy