How to use the FIND function
The FIND function returns the position of a specific string in another string, reading left to right. Note, the FIND function is case-sensitive.
Formula in cell C3:
The formula returns 7 , "friend" is found at character number 7 in text string "Hello friend".
Excel Function Syntax
FIND(find_text,within_text, [start_num])
Arguments
| find_text | Required. Is the text you want to find. ? and * wildcard characters are allowed. |
| within_text | Required. This argument is the text in which you want to search for. |
| [start_num] | Optional. The character number in within_text, counting from the left at which you want to start searching. If omitted 1 is used. |
Comments
If the text string is not found the FIND function returns a #VALUE! error.
To avoid the error use the ISNUMBER function to make the function return TRUE or FALSE, like this:
This extensive function reference list provides detailed information including syntax, arguments, return values, and examples for many of the functions used in Excel formulas. Click on headers to sort table.
Articles with the 'FIND' Function
The following 3 articles have formulas that contain the FIND function.
I read an interesting blog post Is A Particular Word Contained In A Text String? on Spreadsheetpage. That inspired me [โฆ]
Count how many times a string exists in a cell range (case insensitive)
Question: How do I count how many times a word exists in a range of cells? It does not have [โฆ]
Find a sequence of values โ wildcard search
In my last post I showed you how to find a sequence of values. The array formula extracted the row [โฆ]
Functions in 'Text'
The FIND function function is one of many functions in the 'Text' category.
The ASC function converts full-width (double-byte) characters to half-width (single-byte) characters. This function is for double-byte character set (DBCS) languages. [โฆ]
Use CHAR function to convert a number to the corresponding character. This is determined by your computers character set. Windows ANSI [โฆ]
The CLEAN function deletes nonprintable characters in a value, more specifically, it is designed to delete the first 32 nonprinting [โฆ]
The CODE function returns a specific number for the first character of the text argument, determined by your computers character set. [โฆ]
How to use the CONCAT function
The CONCAT function concatenates values from multiple cells. There is, however, no delimiting character or a way to ignore empty [โฆ]
How to use the CONCATENATE function
The CONCATENATE function lets you add text strings into one single text string. The function has been replaced by the [โฆ]
The EXACT function allows you to check if two values are precisely the same, it returns TRUE or FALSE. The [โฆ]
The FIND function returns the position of a specific string in another string, reading left to right. Note, the FIND function [โฆ]
The FIXED function rounds a number to the specified number of decimals, formats the number in decimal format using a [โฆ]
The LEFT function extracts a specific number of characters always starting from the left. Excel Function Syntax LEFT(text, [num_chars]) Arguments [โฆ]
The LEN function returns the number of characters in a cell value. Formula in cell D3: =LEN(B3) Cell B7 contains [โฆ]
The LOWER function converts a value to lower case letters. Formula in cell C3: =LOWER(B3) Excel Function Syntax LOWER(text) Arguments [โฆ]
The MID function returns a substring from a string based on the starting position and the number of characters you want [โฆ]
The REPT function repeats a specific text a chosen number of times. Formula in cell D3: =REPT(B3,C3) Excel Function Syntax [โฆ]
The RIGHT function extracts a specific number of characters always starting from the right. Excel Function Syntax RIGHT(text,[num_chars]) Arguments text [โฆ]
How to use the SEARCH function
Returns a number representing the position a substring is, if found in a textstring. FIND is case sensitive and SEARCH is not.
How to use the SUBSTITUTE function
The SUBSTITUTE function replaces a specific text string in a value. Case sensitive. Formula in cell E3: =SUBSTITUTE(B3,C3,D3) Excel Function [โฆ]
The T function returns a text value if the argument is a text value. Formula in cell C3: =T(B3) The [โฆ]
Excel function syntax TEXT(value, format_text) Converts a value to text in a specific number format. Arguments value - The string [โฆ]
How to use the TEXTJOIN function
The TEXTJOIN function is a new function for office 365 subscribers, it is like the CONCATENATE function on steroids or what the CONCATENATE function [โฆ]
The picture above shows you values that have multiple leading and trailing blanks, sometimes also between words. The TRIM function [โฆ]
How to use the UNICHAR function
Use the UNICHAR function to calculate a character based on a number. Excel Function Syntax UNICHAR(number) Arguments number Required. The [โฆ]
How to use the UNICODE function
Use the UNICODE function to return a Unicode number based on a character. Excel Function Syntax UNICHAR(text) Arguments text Required. [โฆ]
Converts a value to upper case letters. Formula in cell C3: =UPPER(B3) Excel Function Syntax UPPER(text) Arguments text Value to convert. Required. Excel [โฆ]
Converts a text string that represents a number to a number. This function is included for compatibility with other software. [โฆ]
English
Spanish
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form