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:
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. […]
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