![]() ![]() ![]() You will get the error message " Merging cells only keeps the upper-left cell value, and discards the other values." (Excel 2013) or "The selection contains multiple data values. Of course, there is the Merge button (" Merge & Center" etc.), but if you select 2 adjacent cells in order to combine them, as shown in the screenshot: Regrettably, Excel does not provide any built-in tool to achieve this. For example, you want to merge the First Name & Last Name columns into one, or join several columns such as Street, City, Zip, State into a single "Address" column, separating the values with a comma so that you can print the addresses on envelops later. You have a table in Excel and what you want is to combine two columns, row-by-row. From this short article you will learn how to merge multiple Excel columns into one without losing data. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |