Here is the UDF to Convert Numbers to Words in Hindi Language. This can be extended for other Languages as well with little modifications, do let me know your thoughts in comments. How to create the function Called SpellNumber() 1) Start Microsoft Excel. 2) Press ALT+F11 to start the Visual Basic Editor. 3) On the […]
VLOOKUP is my first love of Excel, it is great function to get the corresponding values from a table easily, however there is situation where we might want to get the cell color and font color along with lookup value. VLOOKUP is a function which will return only values, but not the cell formats. Thankfully Excel allows […]
Case1: How many Days/Hours/Minutes it will take to travel 56,986 miles if a vehicle is traveling at constant speed of 12.5 miles per hour? Additional Information: During the travel time vehicle stops for 5 times with 18 hours as break each time Also consider the Overhead/Maintenance time of 100 hours for the one way trip […]
Problem Statement: Is there a way to display complete path of the document and not just the file name in the Excel title bar ? e.g. I would like to see C:\MyExcelFiles\MonthlyBudget.xlsx in Excel title bar instead of just MonthlyBudget.xlsx In Excel, there is no setting/straight way for us to display the full path in […]
Being able to perform a web query to retrieve text or data from a web page is a really useful feature in Excel. Web pages often contain really useful information that is perfect for further data analysis in Excel. Depending on what you need, you can retrieve data that is refreshable or alternatively you can […]
Merged cells have their place in MS Office documents, especially in Word when using a table. They give great flexibility in layout options. There is a big difference between using them in Word and then Excel. Excel cells will probably contain formulas or calculations or data which may link then into other worksheets in the […]
Excel support services will receive scores of different questions each and every day. The range of the questions definitely covers a lot of ground. Among the most common of questions asked is “What are the different types of Excel Macros?” This is a helpful question to ask because if you do not know the different […]
If you’ve ever worked with text files, you’ll know how frustrating it can be to remove empty lines. Part of the problem is that you don’t want to remove every blank line otherwise it might upset the formatting of the document. This article will show you how to remove a set number of blank lines […]
Introduction I have written this article to address requests I have been getting through e-mail on how to automate MS Excel. Most people who are looking at this article might also be interested at the following articles for automating MS Word documents. Here is the link for Automating MS Word using C#, and here is […]
Filtering information out of a larger data set is standard Excel functionality but sometimes it’s necessary to fine tune the filtering to get the information you need. For example, you might have a list of customers prioritized as A,B or C. Additionally, you could have them listed by region. Something like this. Customer, Category, Country […]