ANALYTICS TRAINING HUB

The Excel  FIND  function returns the position of a character or sub-string within a supplied text string. Function returns output only in number form as the starting position of a character. Read More....

Microsoft Excel FIND Function or Formula helps in searching the position of specific character or sub-string in a text string. In this short video, you can learn the use of FIND function to find the the first instance of any character. But you have to be careful as this function is Case-Sensitive and does not support wildcard characters as well. Watch here!

Find Function :-Returning the first occurrence is easy but returning nth occurrence of any character is little tricky. However, In this video, I talked about couple of methods (NESTED Find & FIND along with SUBSTITUTE Function) to return the nth occurrence of any substring in easy steps. You can also combine FIND function along with LEFT function to extract First word or First Name. FIND helps can helps in returning the position of space which later can be supplied to LEFT function, and then LEFT can return specific number of characters from the LEFT side of the text. Watch Here!