Windows  |  Free Downloads




Concatenate in Microsoft Excel

First of all, what the heck is concatenation anyway? We think of Excel as being only able to perform arithmetic functions on data. Wrong. Excel has many features that allow you to work with text data as well.

There are two ways to create concatenation formulas: the hard way and the easy way.

The Easy Way

Suppose you have First Names in column A and last names in column B. Your current task requires them both to be in the same cell. This is so simple, it's ludicrous. Refer to the graphic below.

In the example, we want a space between the first name and last name, so we type it between quotes.

Suppose you wanted to automatically create filenames to assign to a data list that you're going to upload into an online shopping cart program. You have all your graphics prepared as thumbnails and as regular size. You already know that you've used the SKU number, that you added a "t" in front of all the thumbnails, and that they're all JPG files. You've got the SKU number in column C of your worksheet already. You know there must be an easy way, and so there is.

Here's our thumbnail formula. How simple is that?

Our full-size filename formula is even easier:

Copy the formula down! Select all your formula cells, choose EditŕPaste Special, Values, OK. Done.

The Hard Way

This is the one most used by people who don't know the easy way.

Now, I don't know about you, but I can never remember how to spell CONCATENATE! debuted on May 26, 2005. provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Formulas, Functions and Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

Access®, Excel®, FrontPage®, Outlook®, PowerPoint®, Word® are registered trademarks of the Microsoft Corporation.
MrExcel® TM is a registered trademark of Tickling Keys, Inc.

All contents © 1998-2014 by MrExcel Consulting | All rights reserved

privacy policy