Have you ever had to work with a spreadsheet which contained a column full of dates, but you actually needed to see column full of the corresponding days of the week by name? Believe it or not, translating dates to the name of the day of the week is quite Read more…
One of the things that Excel is missing is a way of joining a range of cell values with a common delimiter such as a comma. Here is an example of a range of cells that would be nice to be able to join together with a comma: A B Read more…
One of the commonly misunderstood things about using formulas within Excel is writing cell references. By this, I mean, many people don’t know when to and when not to use the dollar sign before a column name or row number. The dollar sign is used to make the identifier after Read more…
Why would you use the COUNTIF function? This is a question that you may wonder at times. First of all, you could use it to figure out how many cells in a range match the specified criteria. You could also use it to determine whether or not a value in Read more…
Update!!! A newer HTML application (HTA) has just been created which accomplishes the same thing but in a more customizable manner. Click here to read the post. Original Post A few days ago, someone asked me to help them convert a large number of XLS files to CSV. Since, while Read more…
Learn how to get currency inside of a mail merge without extra spaces between the dollar sign and the number.