Merge two or more cells into one

Merge the content of two or more cells in Excel into one cell with this online tool without losing data. Combining two or more cells is easy, whether its text, numbers or formula data. This means you can merge cells without losing data. There are a few different merges you can do, including one that can make email addresses out of a spreadsheet containing just first names and last names! Once the cells have been merged or joined, rows are maintained so that you can copy and paste back into Excel or Word or anywhere else you need it. Works with all versions of Excel 2003, Excel 2007 or Excel 2010. It is also known as concatenating cells or columns. Please note your merges are neither recorded or stored.

Combining two cells into one - names

Perfect for merging or combining 'first names' with 'last names' in separate columns into one cell. You can merge or join more than two cells together in this way no matter what the information is.

Merge cells into one with spaces

Merging addresses into one cell

You may have rows of addresses split up into separate columns, eg house, street, town, etc that you want to join into one cell or line. But you want to separate each part of the address with a comma. The tool lets you use other characters too.

Merge cells for an address

Combining two cells into one with no spaces

If you dont want a space between words or data. Ideal for product codes for example.

Merge cells with no spaces

Join cells, but separate each word with a characters

Perfect if you want to merge the cells in a row into one cell, separating each word by a character instead of a space.

Merge cells with character separation

Email addresses

If you have rows of names and you want to convert them into email addresses you can do with this merge. There is an option to merge with or without a dot inbetween the names.

Make email addresses merge