Combine 3 columns into one in Excel 2011 for Mac
Solution 1
Set up column D to use the formula =CONCATENATE(A1,B1,C1)
then delete columns ABC
Solution 2
Mark's answer doesn't work - if you do these steps, the concatenated cell "D" no longer has data in it.
After doing the concatenate as above, you need to copy the contents of column D and paste them into an empty column - Column E. But don't do a regular paste, choose "Paste Special..." and then select "values." This will paste the data from column D into column E. Now Column E contains the text, and is no longer dependent on any other column. This last step is especially important if you want to copy and past the data out of Excel into something else.
Related videos on Youtube
fightermagethief
Please support my art and writing. It is free, but donations are appreciated. http://www.fightermagethief.blogspot.com
Updated on September 17, 2022Comments
-
fightermagethief over 1 year
I am trying to manipulate a bunch of string elements I have put in columns in Excel. I then filled the preceding column with data, and then the following column as well. Now I want to delete the column boundaries, leaving one column with the data from all the columns in that one. Like so:
A B C 1 @ # @ 2 @ # @ 3 @ # @
And I want it to look like this:
A B C 1 @#@ 2 @#@ 3 @#@
The actual names of the columns and rows are irrelevant, I think, but they are adjacent.