Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to join data from two cells(columns) into one cell in Excel?

In Excel, we can merge two cells into one, but the merged cell only keeps first one cell content. How can we join data from two cells or columns into one row without losing data as below screenshot shown? Now, this article may help you.
doc join data from two cells 1

Join data from cells into one by formula

Join data from cells into one by Save As and Find and Replace function

Join data from cells into one without losing data by Combine Columns and Rows good idea3


Easily Combine columns or rows without losing data in Excel

With Kutools for Excel's Combine Columns and Rows utility, you can quickly combine multuple cells based on row/column and separated by comma or space, or combine a range of cells into a single cell with specific separator.
For instance, here I do thses operations: (1.)Select Select Combine columns under To combine selected cells according to following options; (2.)Specify a separator for the combined data, here I select Space; (3.))Specify the cell you want to place your combined result; (4.)Specify how you want to deal with the combined cells.  Click for full-featured free trial in 60 days!
doc combine cells 1
 
Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 60 days.

Join data from cells into one by formula

Here we have one formula that can quickly merge two cells into one but keep both contents.

Select one cell which you will place the result, type this formula =A1&" " &B1, A1 and B1 are the cells you want to join together, “ “ is the separator between two cell contents, press Enter key, and drag fill handle down to apply the formula to cells.
doc join data from two cells 2


Join data from cells into one by Save As and Find and Replace function

Also, you can copy the cells and paste them into a text file, then do some operations to solve the job.

1. Copy the cells you want to combine, and paste them into a text file.
doc join data from two cells 3

2. Then press Ctrl + H keys to enable the Replace function, in Find what textbox, type tab character, in Replace with textbox, type the separator you use. You can type the tab character in Word document and then paste it to the textbox.
doc join data from two cells 4

3. Click Replace All. The tab characters in text file have been replaced with the specified separators. Close the Replace dialog.
doc join data from two cells 5

4. The copy the texts and paste them back to Excel.
doc join data from two cells 6


Join data from cells into one without losing data by Combine Columns and Rows

If you usually joint data from cells into one, above methods are not good choices. Kutools for Excel’s Combine Columns and Rows utility can quickly combine cells based on rows or columns into one single cell as you need.

Kutools for Excel, with more than 300 handy functions, makes your jobs more easier. 

After installing Kutools for Excel, please do as below:(Free Download Kutools for Excel Now!)

1. Select the cells you use, and click Kutools > Combine. See screenshot:
doc join data from two cells 7

2. In the popping dialog, do as these:

1 Check the option you want to combine cells based on;

2 Check or enter the separator you use;

3 specify the place you want to place the result;

4 Choose one option about the result
doc join data from two cells 8

3. Click Ok. Then the cells have been combined without losing data.

doc join data from two cells 9 doc arrow right doc join data from two cells 10

Easily Combine/Consolidate data based on same value in Excel

Supposing you are working with a worksheet which contains multiple duplicate records, and now you need to combine / merge the rows based on the same value and do some calculations, such as sum, average, count of the duplicate rows. With this Advanced Combine Rows of Kutools for Excel, you can quickly combine same values / same data or duplicate rows into appropriate cells.  Click for full-featured free trial in 60 days!
doc advanced combine rows
 
Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 60 days.
 
 
 
 

Excel Productivity Tools

Ribbon of Excel (with Kutools for Excel installed)

300+ Advanced Features Increase Your Productivity by 70%, and Help You To Stand Out From Crowd!

Would you like to complete your daily work quickly and perfectly? Kutools For Excel brings 300+ cool and powerful advanced features (Combine workbooks, sum by color, split cell contents, convert date, and so on...) for 1500+ work scenarios, helps you solve 80% Excel problems.

  •  Deal with all complicated tasks in seconds, help to enhance your work ability, get success from the fierce competition, and never worry about being fired.
  •  Save a lot of work time, leave much time for you to love and care the family and enjoy a comfortable life now.
  •  Reduce thousands of keyboard and mouse clicks every day, relieve your tired eyes and hands, and give you a healthy body.
  •  Become an Excel expert in 3 minutes, and get admiring glance from your colleagues or friends.
  •  No longer need to remember any painful formulas and VBA codes, have a relaxing and pleasant mind, give you a thrill you've never had before.
  •  Spend only $39, but worth than $4000 training of others. Being used by 110,000 elites and 300+ well-known companies.
  •  60-day unlimited free trial. 60-day money back guarantee. Free upgrade and support for 2 years. Buy once, use forever.
  •  Change the way you work now, and give you a better life immediately!

Office Tab Brings Efficient And Handy Tabs to Office (include Excel), Just Like Chrome, Firefox, And New IE

  • Increases your productivity by 50% when viewing and editing multiple documents.
  • Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
  • Open and create documents in new tabs of same window, rather than in new windows.
  • Help you work faster and easily stand out from the crowd! One second to switch between dozens of open documents!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.