# Combine two Excel columns without losing data

Highlighted
Occasional Contributor

# Combine two Excel columns without losing data

I need a way to combine two Excel columns without losing data. I would like a method which is fast and easy.

14 Replies
Highlighted

# Re: Combine two Excel columns without losing data

What do you mean by combine? Text or numbers? What are you looking for the result to be?

Highlighted

# Re: Combine two Excel columns without losing data

The initial two columns consist totally of text. The combined column will be totally text, with the second text string connected to the first text string.

Highlighted

# Re: Combine two Excel columns without losing data

This information on this link explains how to merge text from two cells, but not two columns.

https://support.office.com/en-ie/article/combine-text-from-two-or-more-cells-into-one-cell-81ba0946-...

Highlighted

# Re: Combine two Excel columns without losing data

I would like to merge the two columns of text into one column of text.

Highlighted

# Re: Combine two Excel columns without losing data

The Merge and Center option on the Excel ribbon loses data.

Highlighted

# Re: Combine two Excel columns without losing data

There are ways to combine data from two cells into one cell. But, I am unable to find a way to combine the data from two entire columns.

Highlighted

# Re: Combine two Excel columns without losing data

Any option I find involves loss of data.

Highlighted

# Re: Combine two Excel columns without losing data

If you have data in A1 to A10    and B1 to B10   then in C1 type = A1&B1 then copy this formula down.

Highlighted

# Re: Combine two Excel columns without losing data

How do I copy the file down?

Highlighted

# Re: Combine two Excel columns without losing data

Copy the formula (Ctrl + c) then select the cells where the formula needs to go and Paste (Ctrl + v)
Highlighted

# Re: Combine two Excel columns without losing data

The column and row identifiers change for each cell, so this copy/paste method will not work.

Highlighted

# Re: Combine two Excel columns without losing data

could you post a sample file please
Highlighted

# Re: Combine two Excel columns without losing data

I combined a sample Excel file with two columns of text. The difference with the real Excel file is that I have over two thousand lines of text, so a manual copy/paste will not be useful.  Also, the version of Excel I am using does not have Power Query.

Highlighted

# Re: Combine two Excel columns without losing data

Hi

It's not clear from the attached file what you want to do.