Tag Archives: Excel-Function

Combine text from two or more cells into one cell in Excel

Excel allows you to merge or combine text from two or more cells into one cell in Excel. Most of the data in active worksheet in not always structured as per your requirement. In that situation you must have to properly set the data in each column separately. After that you must have to know quickly way to combine text from two or more cells into one cell in Excel sheet. Read More

Get the File Names from a Folder using Excel function

Sometime you need to insert the file name list of any format from any specific folder to active worksheet in Excel. This could be done by copy the file name one by one and paste them in the active worksheet. You can use given latest Excel trick to get the file names from a folder using Excel function. Read More

How to use Index Match function in Excel

Just like VLookup function, Match and Index function also used for lookup purpose in Microsoft Excel. Index Match function in Excel works right to left, while VLookup works left to right. In this guide we have to discuss how to use Index Match function in Excel. Read More