How to Convert Dates into Quarter / Year Format

Summary: Convert a list of dates into into quarter and year format. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007 Attachments Convert Dates into Quarters (10 kB)

How to Advance Vlookup to Ignore Extra Spaces Have Been Put Before, in the Middle and After Each name.

Summary: How to Advance Vlookup to Ignore Extra Spaces Have Been Put Before, in the Middle and After Each name. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007 Attachments Advance Vlookup (18 kB)

How to Select Multiple Cells, Rows or columns Without Holding Ctrl+Click

Summary: How to Select Multiple Cells, Rows or columns Without Holding Ctrl+Click. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

How to Automatically Numbering Rows

Summary: How to Automatically Numbering Rows. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007 Attachments Automatically Numbering Rows (22 kB)

How to Create Formulas Comparing Lists for Duplicates

Summary: How to Create Formulas Comparing Lists for Duplicates to see if there is duplicate information. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007 Attachments Formulas for Comparing Lists for Duplicates (17 kB)

How to Create Data Validation

Summary: How to Create Data Validation. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007 Attachments Data validation (17 kB)

How to Delete Duplicate Rows

Summary: How to Delete Duplicate Rows. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007 Attachments Delete Dups (21 kB)

How to Automatically Capitalizing First Letter of Sentence

Summary: How to How to Automatically Capitalizing First Letter of Sentence. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007 Attachments Proper Function (30 kB)

How to Summing Only Positive Values

Summary: How to Summing Only Positive Values. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007 Attachments Summing Only Positive Values (17 kB)

How to Converting Cells to Proper Case

Summary: How to create an Excel Macro to change cells from uppercase to lowercase. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007 Attachments Proper Case (31 kB)