Microsoft Excel Merge two columns for Mac

Have you ever wanted to combine two Excel columns in Mac? Do you have a platform that only has one column for names rather than taking two columns First Name and Last Name? And now you need to merge them. Here’s how you do it:

  1. Create a new column for the merge values
  2. First cell, call it a name
  3. In the second cell, type out this formula replacing it with the cell values:

=CONCAT(COLUMN1,” “,COLUMN2)

EXAMPLE
=CONCAT(C2,” “,D2)

4. Use command button and drag in new column

And Viola!

Screen-Shot-2021-04-06-at-3.23.29-PM-1024x709 Microsoft Excel Merge two columns for Mac

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.