FIND Articles: Excel and Google Sheets

We can use the excel FIND FUNCTION to locate the position of a specific character or substring within a text string in an Excel sheet. The FIND function returns a #VALUE! error if the substring is not found. The steps below will walk through the process. Figure 1: How to...

In many situations, you need to locate the certain character or text string within another string present in cells. By doing so, you can find the presence of that specified character to extract the required information from other string. For this purpose, Excel has built-in FIND function to perform this...