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.

Excel merge two cells into one

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 in Excel without losing data

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 in excel with no spaces

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.

combine cells in Excel

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.

email merge

Make email addresses merge

Tell us right now! Something not worked right? Got an improvement idea? Need some work doing?