Skip to main content

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


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 > Merge & SplitCombine Rows, Columns or Cells without Losing Data. 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 30 days!
doc advanced combine rows
 
Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days.

Best Office Productivity Tools

Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
Super Lookup: Multiple Criteria VLookup    Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ...
Featured Features: Grid Focus   |  Design View   |   Big Formula Bar    Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells    Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more

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...

kte tab 201905


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!
Comments (1)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Muito bom, obrigado!
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations