Excel Tips
Edit Replace to Remove Decimal Points »
May 16, 2002
I just want to know if there is a way to delete decimal point in the amount thus converting it to text.
Gantt Chart With Conditional Formatting »
May 14, 2002
Is there any way to take two columns holding start and stop dates for individual events and create a Gantt type chart without having to leave Excel?
Common Helpful Excel Keyboard Shortcuts »
May 14, 2002
A small list of Excel Keyboard Shortcuts to make your life a little easier.
Conditional Formatting Considering the 4th Option »
May 10, 2002
Conditional formatting allows for 3 conditions. By setting up conditions correctly, you can really allow for 4 conditions when the default formatting of the cell is considered.
Changing NA to an Actual Response Text »
May 9, 2002
VLOOKUP is a powerful tool. Sometimes, if an exact match is not found, a value other than the standard #N/A is desirable.
Function To Merge Two Columns »
May 7, 2002
Area codes are in one column, and a 7 digit phone number is in the next column. How to merge these 2 columns together.
Change All Caps to Proper Text »
May 1, 2002
How to change the case globally so that it is properly formatted.
April 30, 2002