Share via

Office 365 Excel - Want to merge two columns and keep data found in both columns.

Anonymous
2020-02-24T19:23:25+00:00

I am running Office 365 and working in Excel.  I have one spreadsheet that has the name split out into two columns, column B - First Name and column C - Last Name.  I have another spreadsheet that has the name in one column, column B - First, Last Name.  I need to combine these two spreadsheets and would like to convert the two column name to a one column name (my management wants to see one column for the name.)  I found where the column can be split into two different columns, but I want to go the other direction.  Is this possible?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2020-02-24T20:26:04+00:00

    Yes - just use a column of formulas like

    =A2 & ", " & B2

    or  

    =B2 & ", " & A2

    Then copy those formulas, paste values over the formulas, and remove the un-joined columns.

    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-02-27T12:09:03+00:00

    Thank you so much.  It works perfectly.

    0 comments
  2. Anonymous
    2020-02-27T12:08:33+00:00

    Hello,

    I was able to try the reply from Bernie Deitrick and was able to complete my project.  Thank you.

    0 comments
  3. Anonymous
    2020-02-27T00:32:09+00:00

    Hi Clark98,

    Did you check above reply from Bernie Deitrick? If you still need help, please update us when you have time.

    Regards,

    Neha

    0 comments