How to do a mail merge using Microsoft Word and Excel to quickly create personalized templates for imported data

You can do a mail merge in Microsoft Word and Excel to create personalized documents for many recipients at once.

How to merge and unmerge cells in Microsoft Excel in 4 ways, to clean up your data and formatting

You can merge cells in Excel by using a simple drop-down menu, which will let you merge cells in a variety of ways. Here's ...
How-To Geek on MSN

How to Use the VSTACK and HSTACK Functions in Microsoft Excel

VSTACK and HSTACK are dynamic array functions, meaning the result spills from the cell in which you type the formula, and any changes to the data in the source arrays are reflected in the stacked ...
NewsBytes

How to automate data cleaning in Excel

Excel's text functions, such as TRIM, UPPER, LOWER, and PROPER, can be used to clean up textual data. TRIM removes extra ...
How-To Geek on MSN

Everything You Need to Know About Array Constants in Excel

Array constants can only contain text in double quotes, plain numbers (no currency symbols or percent signs), or Boolean ...