+ Reply to Thread
Results 1 to 3 of 3

How to Merge columns with First name and Second name

  1. #1
    Registered User
    Join Date
    04-11-2012
    Location
    California
    MS-Off Ver
    Excel 2003
    Posts
    1

    How to Merge columns with First name and Second name

    hello,

    I'm a novice, and this might be a bit simple for some of you excel masters. Please, someone put me out my misery!

    I have a report with like 20 columns with first and last names and I'd like to merge them into one listing column

    Ex.

    John | Doe | Tom | Smith | Mike | Jones etc... for like 20 columns

    I'd like

    John Doe, Tom Smith, Mike Jones,... in one column e.g., column K

    or

    John Doe
    Tom Smith
    Mike Jones... column K

    Thanx Much for the help

  2. #2
    Registered User
    Join Date
    08-24-2010
    Location
    California
    MS-Off Ver
    Excel 2007, 2010
    Posts
    45

    Re: How to Merge columns with First name and Second name

    Assume your data is in row 2 and there are 6 columns of first/last names, the formula in the aggregate cell G2 that contains 3 names all together should be:

    G2 = trim(A2) & " " & trim(B2) & ", " & trim(C2) & " " & trim(D2) & ", " & trim(E2) & " " & trim(F2) ....

    You get the idea - basically add an empty space between each first/last name pair, and add a ", " between neighboring names.

  3. #3
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: How to Merge columns with First name and Second name

    Hi
    You can use the concatenate function to do this. If you could provide a sample file I could show it to you.
    Click *, if my suggestion helps you. Have a good day!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1