How to use the FIND function in Excel

Опубликовано: 01 Март 2019
на канале: Essential Excel
94
2

Did you know Excel has a function called FIND that will search a supplied string for your desired search term? It is in fact one of the most useful string functions that will return the position of your search term within the supplied string.

In this tutorial we demonstrate how to use the FIND function by stepping through a number of scenarios that you can easily follow along with.

SUMMARY

The Excel FIND function returns the position (as a number) of one text string inside another. However when the text is not found, FIND returns a #VALUE error.

HAVE A QUESTION

If you have any questions please drop a comment below and I will respond soon as possible. Also do not forget to like and subscribe for more content!

USEFUL LINKS

Download tutorial workbook 📊
https://www.essentialexceluk.com/2019...

More Tutorials 👇
   / essentialexcel  

#excel #find #tutorial #office365 #microsoftexcel


Смотрите видео How to use the FIND function in Excel онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Essential Excel 01 Март 2019, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 94 раз и оно понравилось 2 людям.