Excel FIND function can be used when you want to locate a text string within another text string and find its position.
It returns a number that represents the starting position of the string you are finding in another string.
ADDITIONAL NOTES:
— If the start number is not specified, then it starts looking from the beginning of the string.
— Excel FIND function is case-sensitive. If you want to do a case-insensitive search, use Excel SEARCH function.
— Excel FIND function can not handle wildcard characters. If you want to use wildcard characters, use the Excel SEARCH function.
— It returns a #VALUE! error if the searched string is not found in the text.
Read More –
Free Excel Course –
Paid Online Training –
Best Excel Books:
⚙️ Gear I Recommend:
Camera –
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic –
Wireless Mic:
Lighting –
Subscribe to get awesome Excel Tips every week:
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Which formula should i use to get Second "e" in 'Excellent'…??
hello, do you know a formula equivalent to CTRL + L? thanks
=FIND(A1,B1,1)
What if i want it to say TRUE or FALSE?
Hmmm… didn't understand this one!
Sir, plz guide on how to use Columns and Rows Function combining with Averageifs Formula in Excel.
super
If there's two "E"'s in a word how can you find the second "E" instead of the first one?
It does not matter what number I input in the last part, I always get the result as if counting from the beginning of the word.
Want to learn about UFD user defined functions
U are excellent in excel
Thanks from Sweden!
Hi Sumit,I think u don't have published any video on . how to make compound interest forumula in excel, recurring deposit and fixed deposit formula. there are videos in youtube. but your style is excellent and no one else provide excel sheet along with the video.can you please make this also.
IF large data in cell how i will find on word?
ex: User comment ( I am not able to get SMS banking in my mobile)
how i will find "SMS Banking" with Find formula, I am trying Its coming Name Error, can u help me
HelloI am in Trouble with Unknown Link in my workbookin Edit Links Dialogue Box Status is UnknownI am tired to find the cell which Link with another Work bookcan you help me how can I search those Cells of work sheet?
Start-Num Is Optional, If You Leave It (=FIND (A2,A3)), It Is 1, By Default. Just To Make Formula Shorter