How to use FIND Formula in Excel

Опубликовано: 11 Март 2014
на канале: TrumpExcel
124,016
465

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 - https://trumpexcel.com/excel-function...





Free Excel Course - https://trumpexcel.com/learn-excel/
Paid Online Training - https://trumpexcel.com/excel-training/
Best Excel Books: https://trumpexcel.com/best-excel-books/

⚙️ Gear I Recommend:
Camera - https://amzn.to/3bmHko7
Screen Recorder - techsmith.z6rjha.net/26D9Q
USB Mic - https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting - https://amzn.to/2uxOxRv

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial