How to use Find Function in Microsoft Excel

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!