The FIND function in Excel is used to return the position of a specific character or substring within a text string. Select an empty cell where you want the answer displayed. Select the Formulas tab.
Were also adding a bonus method by showing you the math behind NPS and how you can calculate it with pen and paper should you ever want to.
The Microsoft Excel INT Function is a function that is responsible for returning the integer portion of a number. First thing to do is to know the size of your matrix that you want to create in Excel. Type the equal symbol in a cell. The FIND function in Excel is used to return the position of a specific character or substring within a text string.