Excel For Power

The excel index function returns a value from a table or range based on the row and column numbers specified. There are two types of Index function, one which returns a single value and another which returns a range values.
here is the syntax of the index function which returns a single value...

In Vlookup function we normally provides static column number of a table to retrieve data. This way the function is not resilient and may return wrong data if any new columns are inserted in the table.
We can create a dynamic column number by using Match function which will find the right column based on its name. The resultant function is called two-way lookup or two dimensional lookup function which returns intersecting value of row and column...

Rand and Randbetween
Random functions are very useful if you want to simulate some process in Excel without entering the random numbers manually – example rolling a dice or for What if analysis or for Solver / Scenario
Rand() – This function has no arguments and returns a decimal between 0 and 1....

Hi someone asked me whether one could remove just the numbers in a cell which contains text plus numbers and retain only the text part.
For example the cell value is "jj44892hpe7895"
The result after removing the numbers will be "jjhpe"