FIND
Returns the position of a text string (first occurrence) within another given text string.
Syntax
find_text: Text string whose position you want to obtain. E.g. "S"
text_to_search: Text to search for the first occurrence of specified text string. "Zoho Sheet"
Remarks
The FIND function is case-sensitive i.e., "Apple" and "apple" are treated the same.
Examples
Formula | Result |
=FIND("S";"Zoho Sheet") | 6 |
=FIND(A3;B3) | 5 |
=FIND(A4;B4) | 3 |
Possible Errors
Errors | Meaning |
#N/A! |
|
#NAME! |
|
#VALUE! |
|
#REF! |
|
Similar Functions
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Zoho DataPrep Resources
Design. Discuss. Deliver.
Related Articles
Find and replace data
To find particular data and replace it with another: Go to Home in the menu bar and tap Find & Select. Enter the data you wish to find in the sheet and tap Find. To find and replace the data, enter the actual data and the data to replace it with. You ...Find and replace data
1. Click on the Search bar on the right top corner. 2. Click on the drop down menu in the search bar, and from there choose More options. 3. Once this done, a Find and replace dialogue box will appear. 4. In the dialogue box, key in the word you are ...Find and replace values in a spreadsheet
To find and replace values in your spreadsheet: Go to the ... icon, then choose Find and Replace. Enter a value to search in the current worksheet. Navigate between the found values using the icons. Tap the icon to customize the search and to ...Find and remove data inconsistencies
1. Click on the Data menu. 2. From the Data Cleaning option, select Fix Data Inconsistencies from the drop down. 3. In the data cleaning panel, choose a column from which you want the tool to pick the inconsistencies from. 4. The tool will list down ...SEARCH
Returns the position of a given character or text string in a given text string. Syntax SEARCH(find_text; to_search; start_position) find_text: The character or text string you want to find. E.g. "e" to_search: The text in which you want to ...