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.