![how to merge cells in excel without losing data of 2 cells how to merge cells in excel without losing data of 2 cells](https://content.spiceworksstatic.com/service.community/p/how_to_step_attachments/0000085446/544ffba0/attached_file/7384ddf1f8b5619fb241b8e0b3dc019d2d09627228f4168a456c50d8c5cecb47_doc-merge-columns-data3.png)
- #HOW TO MERGE CELLS IN EXCEL WITHOUT LOSING DATA OF 2 CELLS HOW TO#
- #HOW TO MERGE CELLS IN EXCEL WITHOUT LOSING DATA OF 2 CELLS UPDATE#
#HOW TO MERGE CELLS IN EXCEL WITHOUT LOSING DATA OF 2 CELLS UPDATE#
When you update the old list with a new value you need to refresh your query and it will add that new value in the cell. The best thing about using Power Query is you don’t need to do this setup again and again. Now, you have a new worksheet in your workbook with all the text in a single cell.
![how to merge cells in excel without losing data of 2 cells how to merge cells in excel without losing data of 2 cells](https://blog.hubspot.com/hs-fs/hubfs/merging-cells-example.jpg)
You can also use it to combine text from a list in a single cell. Make sure to check out this ( Excel Power Query Tutorial). Power Query is a fantastic tool and I love it. In the end, hit enter and you’ll get all the text in a single cell. Here you have used space as a delimiter, TRUE to ignore blank cells and the entire range in a single argument.
![how to merge cells in excel without losing data of 2 cells how to merge cells in excel without losing data of 2 cells](https://cdn.extendoffice.com/images/stories/doc-excel/merge-cells/doc-merge-columns.png)
#HOW TO MERGE CELLS IN EXCEL WITHOUT LOSING DATA OF 2 CELLS HOW TO#
See: How to merge cells in Excel and Calc.
![how to merge cells in excel without losing data of 2 cells how to merge cells in excel without losing data of 2 cells](https://i.ytimg.com/vi/5SQRyD0-TkY/maxresdefault.jpg)
This page is for combining the values of cells, which is not the same as merging multiple cells.