Concatenate is a function in Microsoft Excel that can be used to string multiple data cells together – for example, adding spouses' first names together for a mailing list. Additional text may be included in your formula by enclosing it in quotation marks. This handy trick could save you some time getting those Holiday Cards out the door!
Once you have your string of text combined the next step would be to copy the formula down your column, then highlight your entire column, right-click to Copy; now highlight an empty column, right-click to Paste Special and choose Values. It's that easy!
- April Leabo