Abdul Alim: a little bit learning, let's go

Excel, VBA and Power BI tutorials 

FIND Formula

FIND formula returns the location of a sub-string in a string. The search is case-sensitive. 

Syntax

FIND(find_text, within_text, [start_num] )

Parameters Details:

• find_text : The sub-string that you want to find.

• within_text : The string to search within.

• start_num : Optional. It is the position in string where the search will start. The first position is 1.

Returns

The FIND function returns a numeric value. The first position in the string is 1.
If the FIND function does not find a match, it will return a #VALUE! error.