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.
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 
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.
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.
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.
3. Click Replace All. The tab characters in text file have been replaced with the specified separators. Close the Replace dialog.
4. The copy the texts and paste them back to Excel.
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.
After installing Kutools for Excel, please do as below:（Free Download Kutools for Excel Now!)
1. Select the cells you use, and click Kutools > Merge & Split > Combine Rows, Columns or Cells without Losing Data. See screenshot:
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
3. Click Ok. Then the cells have been combined without losing data.
 |  |  |
Demo: Combine Columns or rows using Kutools
Easily Combine and Consolidate Data by Value in Excel |
If you're working with a worksheet containing duplicate records, Kutools for Excel's Advanced Combine Rows feature allows you to quickly merge rows based on the same value. You can perform calculations like sum, average, or count on duplicate rows, making data consolidation fast and efficient. |
|
Kutools for Excel - Supercharge Excel with over 300 essential tools. Enjoy permanently free AI features! Get It Now |
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
All Kutools add-ins. One installer
Kutools for Office suite bundles add-ins for Excel, Word, Outlook & PowerPoint plus Office Tab Pro, which is ideal for teams working across Office apps.
- All-in-one suite — Excel, Word, Outlook & PowerPoint add-ins + Office Tab Pro
- One installer, one license — set up in minutes (MSI-ready)
- Works better together — streamlined productivity across Office apps
- 30-day full-featured trial — no registration, no credit card
- Best value — save vs buying individual add-in