You will notice that the results will give you a numeric array with an equal number of rows and columns. There are two other methods to use the MINVERSE function. Method one is to click the fx button ...
Create a table or use an existing table. In this tutorial, we have the text ‘hhans 1997‘ in the text column; we want to substitute the’ h‘ with an ‘s.’ Click the cell where you want to place the ...