ARABIC function

Excel 2013 has given us a function which converts a Roman number to an Arabic number. For example, if you wish to convert the Roman number ("XII") ...

Extracting last Word

Problem: Creating a formula to retrieve the last word from a string Solution: Using the MID, FIND, SUBSTITUTE and LEN text category functions, ...

How to use the UNICHAR Function in Excel

In this article, we will learn about how to use the UNICHAR function in Excel. UNICODE is computing standard for the unified encoding, representati...

Tracing Errors in Formula Results in Excel 2007

To trace an error: 1. Select cell B1 (a cell containing an error). 2. Select Formulas -> Error Checking (in Formula Auditing Group) -> Trace...

Get adjacent value of a cell having minimum value in a range

If you have a range of values in one column and the corresponding names of individuals in another column.  You may want to find out the name of the p...

Restricting the Automatic Recalculation of Volatile Functions

Problem: When using volatile functions, such as NOW and RANDBETWEEN, the results change whenever changes are made to the worksheet. Can we restric...

Get filename from path

Many a times, we have the entire path of the filenames and we would only want to extract the name of the file from the entire path. We can do this eas...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube